Sorting

You can customize the sorting behavior of dimension fields in each widget. You can order them based on alphabet or value, data source (default), or field.

Dimension column

To customize the sorting behavior of dimension fields, drag and drop the Dimension Field into the control designer.

Click the Settings icon available in the Columns, Rows, or Series section, and select Sort from the context menu.

The Advanced Sorting Options dialog will open as shown in the following image.

The options available in the Advanced Sorting Options dialog are:

Sort order

• Ascending: Displays the sorted results in ascending order.

• Descending: Displays the sorted results in descending order.

Sort by

• Alphabetic: Orders the data either in ascending or descending order based on the initial alphabet. You can apply this sorting for more than one string field. Here, the data has been ordered in a hierarchical pattern.

  

• Data source: Places resultant data from the data source on query execution without performing any additional operations such as ascending or descending.

  

• Field: Orders the data based on the associated values of another measure or dimension field. For example, you can order several countries based on their freight values.

  For example, the sort dialog box shown below is configured to sort the “Ship Name” field based on the sum of the “Freight” measure in ascending order. The results will be displayed in such a way that the “Ship Name” with the lowest “Freight” value is displayed first and the “Ship Name” with the second lowest “Freight” value is displayed second, and so on.

  

  

NOTE: Advanced sorting is not available for “date” type, “date time” type, raw data, and proportional charts such as pie, doughnut, pyramid, and funnel.