Sort

Sorting helps you analyze dashboard data more effectively by arranging values in a meaningful order. For example, you might sort products by revenue to quickly identify top performers.

You can apply sorting to dimension fields in a scenario using the Sort dialog. Sorting can be based on alphabetical order, measure values, data attributes, or a custom manual order.

Note: Some scenarios do not support sorting, including KPI Chart, Indicator, Gauge, Data Table, Rich Text, and Image.

Applying a Sort

1. Select the scenario you want to sort. The Action Bar appears on the right side of the scenario.

2. Click the Sort icon from the Action Bar.

3. In the Sort dialog, click Add Sort to define sorting conditions.

4. Set the Target Field to the dimension you want to sort (e.g., Products).

5. Choose a sort method from the available options (described below).

6. Click Apply, then OK to view the result.

Sort Methods

1. Items

Sorts dimension values alphabetically.

• Sort Order: Ascending or Descending.

2. Value

Sorts dimension values based on a bound measure (e.g., Revenue).

• Sort By: Choose a measure from the list.

• Sort Order: Ascending or Descending.

3. Field

Sorts dimension values based on a data attribute.

• Sort By: Choose an attribute (bound or unbound).

• Sort Order: Ascending or Descending.

4. Manual

Define a custom sort order by arranging values manually.

Use Up, Down, Top, and Bottom buttons to reorder values.

Only target field values are shown.

Example: Sorting Products by Revenue

1. Select the chart scenario displaying products.

2. Open the Sort dialog and click Add Sort.

3. Set Target Field to Products.

4. Choose Value as the sort method.

5. Set Sort By to Sum of Revenue and define the Sort Order.

6. Click Apply → OK.

The chart now displays products sorted by revenue, helping you identify top-selling items more easily.