Limit Viz to the Top N Values
Security:
Discovery Boards: Create
domain in the System functional area.Another way to filter data in a visualization is to apply a limit on the number of attribute values displayed. You can limit attribute values in these viz types:
- Area Chart
- Bar Chart
- Chart
- Donut Chart
- Heatmap
- Line Chart
- Scatterplot
- Pivot Table
Workday limits the data if the number of unique values exceeds the configured limit. Workday automatically defines different limit values depending on the viz type and drop zone. Example: Workday automatically limits the
Color
drop zone in Donut Chart vizzes to 20 values. You can change the limit values of different drop zones, up to a different maximum for each.Limiting data in a viz works with how you sort the data. You can change how you sort the data when you edit the limit settings.
For most viz types, you can sum all other values into a single value labeled Other. You can't sum all other values in a Pivot Table viz.
You can limit the values in a Waterfall viz when there's a field in the
Dimensions
drop zone. For details, see Opties voor watervalvisualisatie instellen.- Select a viz with at least 1 attribute field in a drop zone.
- Click the drop zone options for theX-Axis,Columns,Rows, orColordrop zone that contains an attribute field.When you change the orientation of a Bar Chart viz to horizontal, you can click theY-Axisdrop zone options.
- Select the number of values toLimit.
- (Optional for Area Chart, Bar Chart, Chart, Donut Chart, Heatmap, Line Chart, and Scatterplot) SelectSum Remaining Values.