Sorting tiles by performance
You can sort the tiles in a KPI chart in 'Best first' or 'Worst first' order by measures that you specify per KPI. The sorting includes the tiles from all existing KPIs in the KPI chart.
Right-click the KPI you want to include in the sorting, and select
Properties in the opened menu.
The Properties pop-over is displayed.
In the pop-over, select
The Sorting section is shown.
- Under Sort tiles by, specify which measure to use for sorting the tiles. You can
- Repeat step 1 to 3 above until you have specified a sort order for each KPI you want to include in a Best first or Worst first sorting.
- Right-click the KPI chart to display the pop-up menu.
- Select or .
The KPI chart below contains two KPIs. The first KPI shows the number of visitors at different stores. The primary values in the tiles for this KPI are specified to be used for sorting, that is, on Sort tiles by, the Visitors column is selected.
The second KPI shows sales figures for different fruit types as primary values in the tiles, and purchase figures as the comparative values. Also in this KPI, the primary values are specified to be used for sorting, that is, on Sort tiles by, the Sales column is selected.
Sorting the tiles using the Best first order results in the KPI chart below. The primary values from both the KPIs are sorted starting with the highest value.