Overview
Dashboard charts support Top N analysis — show only the “top N” or “bottom N” items to focus on what matters, simplify dense views, and decide faster.Common scenarios
- Sales analysis: see the top 10 products by revenue — pinpoint core SKUs fast.
- Cost control: surface the bottom 5 regions by profit — flag problem areas early.
How to use
Prerequisites
Before using Top N, confirm your permissions:- Advanced permissions on → admin/owner only.
- Advanced permissions off → anyone with edit or manage permissions (including admin/owner).
Enable Top N
- In the dashboard, select the chart to configure — open the config panel.
- In the config panel on the right, click the Analysis tab.
- Find Top N — toggle it on.
Configure ranking rules
1. Pick a ranking method
Available ranking methods depend on chart type:-
XY-axis charts (column / line / bar / area / combo / radar / scatter)
- Rank by category sum: rank categories (e.g., “product category”) by total value.
- Rank by series value: rank by a specific data series (e.g., “profit”).
- Rank by series within each category: rank series independently inside each category.
- Rank by series sum: rank series by their total across all categories.
-
Pie / donut chart
- Fixed to rank by sector value — compare each slice directly.
2. Set how many to keep
- Direction:
- Top N: show the N highest values.
- Bottom N: show the N lowest values.
- Count: enter a positive integer (e.g.,
10,5).