order the split by values in Dashboards

[calfano]

Is there a way to specifically pick the order I want the split by to be displayed?

For example I want the value that's blue at the very top followed by red then yellow

To me it looks like it's alphabetical? 

Thanks.

[p_devulapalli]

I've not tried it in the classic dashboards , but I think this can be done in Notebooks/New Dashboards using the "Series overrides" under Bar chart options .

Please give it a try 

https://docs.dynatrace.com/docs/shortlink/visualization-chart-bar#series-overrides

[calfano]

Yeah but as far as I'm aware if I have two fields and I want one field displayed on top of the other, it's not possible right? in your screenshot if there was another series called storeC could I be able to display storeC ABOVE storeB?

[p_devulapalli]

Yea, it does seem to work with series overrides, whatever I select from drop down seems to be showing up on the top when I have multiple options to select

[Fin_Ubels · Accepted solution]

Testing it out in my environment, if using a bar chart you can choose the order by using the sort function in DQL. For example the bellow is ordered by hostname:

timeseries avg(dt.host.cpu.usage), by:{host.name}
| sort host.name desc

If I then sort ascending the order flips as expected. Removing the sort, it appears to be reverse alphabetical by default.