I have created a Dashboard with a Chart View bar chart based on a data table.
The X-axis is a nominal data type, and the Y-axis is a numeric data type.
The bar chart is sorted alphabetically by the x-axis name, but I would like to change this to sort by the Y-axis value to look like a pareto chart. I’m guessing there’s no option for this?
I think I can force a change in the sort order by creating a calculated column where I pre-pend the nominal text with integer values, such as 1-someColumnName, 2-anotherColumnName, etc., but I’m hoping I don’t have to resort to this hackery.
Thanks.