Limit Items
Too many items in the chart? Limit the chart to the top n items, or create bins of numerical values to reduce the noise in the chart.
Open the Limit Items panel from the left sidebar.
Using Limit Top Items to reduce the number of bars on the X-Axis to 7
Limit Top Items
Limit the number of items shown to the largest n or smallest n items. Can also pick which axis is filtered and whether to group the remaining items into an Others category.
-
Limit Top Items Toggle this switch on to limit the number of items appearing in the chart
-
Max # of Items Specify the maximum number of items to show in the chart. For example, if a bar chart with 25 bars was produced, enter 10 in this field to limit it to the top (or bottom) 10 items.
-
Values to Keep Choose to either show the largest n items in the chart, or the smallest n items in the chart.
-
Axis to Limit Choose the axis that should have its items limited. The X Axis is chosen by default and may be the only option. If a grouped chart type is selected, you will be able to choose the Groups Axis to be limited.
-
Group the rest into All Others Category Check this checkbox to group any items that were too small (or too large) to pass the limit into an Others category. This option is not available for numeric or date columns.
Create bins for numerical values
This option is turned on by default, and limits the number of items drawn in the chart by putting numerical values into ranges or bins.
Ex: Instead of plotting individual numbers between 1 and 200, it will create bins of 0-50, 51-100, 101-150, 151-200. This reduces the amount of data points plotted.
-
Auto Bin Turn this off for finer control of binning. By default, most numeric values on non scatterplot charts will be binned.
-
Bin X-Axis Toggle this on or off to control binning on the X-Axis
-
Bin Group Axis Toggle this on or off to control binning on the Group Axis