I'm using the Chart widget, and am trying to limit the number of categories that will display in a bar chart using the "Maximum Categories" option under the widget's Content pane; Data settings group. It is a stacked bar chart using the "Split by Field" option. However, the app/widget continues to show many more categories over the limit I've set. If I disable the "Split by Field" option, it works as intended. In the Experience Builder documentation, it only says that you must use the "By Group" category type to have this option (which I am).
I did notice that if I lower the Maximum Categories number, (for example to 5) it will show less categories in the chart, but still many more than what I set the maximum number to. In the case of lowering it to 5, it instead shows 14 in the chart (out of 40)
The settings I'm using are in the table below. Can anyone else reproduce this issue? Is there another undocumented requirement for this setting related to the Split by Field?
Category Type | By Group |
Category Field | Text Field 1 |
Statistics | Count |
Split by Field | Text Field 2 |
Sort by | Value / Descending |
Maximum Categories | 25 |
-Aaron