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 :

Widget field 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.

Last modified: May 09, 2023

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment