Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
People,
Good afternoon!
I would like to sort a dimension (hour) in a bar chart, but it's not working. Could you help me, please?
put your hour dimension in the sorting tab above all the other fields
in Sorting Option
1st should be your Dimension (Hour)
Screenshot shows that you have sorted according to your measure.
In Sorting, Put Measure at 2nd Position
It worked!!!
I'm totally newbie! 😃
Thanks, omar!
Hi
If the above aren't working correctly, it could be it is treating the values as a string.
Make sure it is at the top in your sorting.
Turn off auto sorting.
Choose sort by Expressions.
Add NUM(Hour) or what ever the dimension is called.
Mark
Hi,
In the sorting tab, move the hour dimension to the first and select "sort numerically" - ascending.
"Sort numerically" will work if he hour dimension is numeric. If it is string then you need to convert it into num using num#.
Thanks!