Hey,
I want to sort this graph by the ‘hour’ (X Axis) and then by the ‘value’ (Y Axis).
Currently the graph is sorted only by the ‘hour’.
I couldn’t find a way to do so.
Can you please help me?
Thanks ahead.
Hi @Eldad_Levi ,
There is no direct way that I can think of other than creating a sortkey out of the fields you want to sort by. And sort by reference of the sortkey.
You can think of using rank as sortkey for this case or make a combination of yyyymmdd integer and value order.
Thanks,
Prantika
Hey, Thanks for responding.
A sortkey might sort the columns as I wish, but I can’t present the two columns I want to present on the graph together with the sortkey right?
Thanks ahead,
The current configuration from the snip shows both the hour and value label in the visual. You can keep the fields used as same in the above visual and use the sortkey only to sort x axis. In that way you would still be showing the values you want.
Alternately if you want to show multiple field values in x axis there is an approach to create a sort label as well or use the small multiples field to break down the line chart based on the use case.
Ok got it. I understood how to manage it. Thanks a lot!
1 Like