Sorting and Top N

The Innofalls Chart offer you the possibility to sort the elements in a chart. You can specify by which measure and/or dimension the chart should be sorted by. You can also sort by deviations to quickly identify elements with the largest impact.

You can activate sorting by either clicking on a axis label

When Top/Bottom N is active, you can also click the Rest label to open the settings dialog.

Sorting

When more than one measure or additional deviation charts are available in the visual, you can choose by which measure to sort by.

When the Stack / Columns field contains a dimension, you can select which member to sort by.

Sort Options

Top / Bottom N

You can apply this option, if you wish to limit the amount of elements shown in the chart. When this constraint is active, the N number of elements with the highest (top) or lowest (bottom) values are shown and all other elements are summarized in a rest member.

You can either specify a fixed number of elements to keep or you can choose one of the Auto settings to determine the number of elements to keep automatically. Auto is a good choice for responsive reports (e.g. mobile reports). The smaller the visual, the fewer elements are visible.

If the number of elements present is less than the constraint N, no Rest is generated.

You can rename the Rest member in the property pane under Sorting + Top N.

Top / Bottom N Options

Last updated