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:
|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?