Contact Support
Advanced Sorting
You can customize the sorting behavior of dimension fields in each widget based on your needs. You can order them based on Alphabet, Data Source (Default), Field or Manually.
To do so, first drag and drop the dimension field into control designer.
Click on the Settings
icon available in the button and select Custom Sort
option from the context menu.
Now you can see the Advanced Sorting Options
dialog opened and look like in the below image.
Let’s now see the options available in Advanced Sorting Options
dialog briefly.
Sort Order
-
Ascending
- Displays the sorted results in ascending order. -
Descending
- Displays the sorted results in descending order.
Sort By
-
Alphabetic
– Orders the data based on initial alphabet, either in ascending or descending. You can apply this sorting for more than one string field and during this scenario, we will order the data in hierarchical pattern as shown below.
-
Data source
- Places the resultant data from the data source, on query execution, as such without performing any additional operations like ascending or descending as shown below.
-
Field
- Orders the data based on the associated values of another measure or dimension field. For example, you could order several countries based on their their freight values.
When sorting with another field option, you must also specify the aggregation function to use. This option is not applicable for SSAS data sources because aggregations are defined when the cube is created and cannot be modified.
For example, the sort dialog box shown below is configured to sort the “Ship Country” field in ascending order and by the sum of the “Freight” measure. The results will be displayed in such a way that the “Ship Country” with lowest “Freight” value is displayed first and the “Ship Country” with the second lowest “Freight” value is displayed second, and so on.
-
Manual
- Manual sorting allows you to re-arrange the values extracted from a table column through simple drag and drop operation as shown below. You can apply this sorting for more than one columns. This sorting is not applicable for SSAS data sources.
NOTE
As of now, Manual sorting is not available for “Date” type, “Date Time” type. Custom Sorting Option is not available for Raw Data, and proportional charts like Pie, Doughnut, Pyramid and Funnel.