[]
        
(Showing Draft Content)

Sort

Sorting helps visualize dashboards by arranging the data in some meaningful order. Users can apply sort on the dimension values of a scenario in ascending or descending order. For example, you may want to sort the products by sales revenue to find the top-selling products.

Sorting Products in Chart Scenario

Use the Sort dialog to specify the sort conditions. The available options in the Sort dialog are described as follows:

Options Description
Target Value Refers to the value on which you want to apply the sort. Note that you can apply sort only to the bound dimensions
Items Sorts the target field alphabetically.
Sort Order - Specify the sort order as Ascending or Descending.
Value Sorts the target field by measure values. Specify the Sort Order and Sort By.
Sort By - Select the measure from the list. Note that the list contains only the bound measures.
Field Sorts the target field by data attributes. Specify the Sort Order and Sort By.
Sort By - Select the attribute from the list. Note that the list contains both the bound and unbound data attributes.
Manual Use this option to create a custom sort order. Use the Up, Down, Top, and Bottom buttons to arrange the values in the list. Note that the list contains only the target field values.

Note: Some dashboard items that do not support the sort feature are - KPI Chart, Indicator, Gauge, Data Table, Rich Text, and Image.

Applying a Sort

  1. Select the dashboard scenario on which you want to sort the data. Note that an Action Bar automatically appears on the right of the selected scenario.

  2. From the Action Bar, select Sort actionSort Icon.

    Select Sort from the Action Bar

  3. In the Sort dialog that appears, click Add Sort to specify the sort conditions.

    Specify the sorting conditions

  4. Set the Target Field to a suitable dimension from the list. For example, set the Target Field to 'Products' to apply sort on the 'Product' values.

    Setting the Target Field to Months

  5. Choose the Value option since we are sorting the target field by the bound measure value, 'Revenue'.

  6. Set Sort By to 'Sum of Revenue' from the list and Sort Order to either ascending or descending.

    Specify the sort by and sort order fields

  7. After specifying the sorting conditions, click Apply and then OK to see the result.

    Saving the sorting conditions and previewing the result