I am using the Bar Chart widget to display values, but I would like to sort by a different column. For example, using the following data:
SortOrder | DisplayTitle | Value |
1 | zero to 30 | 12 |
2 | Up to 90 | 2 |
3 | More than 90 | 78 |
Configured using Value in the Value(s) section, and the DisplayTitle in the Column(s) section, the bar chart only allows sorting by the Value column. I would like to sort by the SortOrder column, but I am not given this option currently.
Is there a way to sort by the SortOrder column without it showing on the Bar Chart?
Thanks.