Introduction
Most Widgets will present data differently depending on how it is sorted in the query.
Example : a Chart is by default sorted by ascending X Axis values. It can instead be sorted by descending Y Axis values.
Sorting Priority
As a rule, the fields at the top of the Data binding panel will have sorting priority over the fields below.
Example : if you set a Chart Y Value field sorted descending, it will override the X Axis sorting because it is located above in the Data binding panel.
Configure sorting
On each bound data field, you can configure sorting :
- by default : do not take part in query sorting
- Asc : sorted in Ascending order
- Desc : sorted in Descending order
Sorting start element
Value grouping charts offer customized data ordering. This might be useful if one would like to display sorted data from a selected first element.
The configuration is made on widget configuration panel as shown below:
In this example, we can define the starting month in the chart.
Post your comment on this topic.