topic Re: order the split by values in Dashboards in Dashboarding

order the split by values in Dashboards

calfano — Thu, 05 Sep 2024 21:01:46 GMT

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.

Re: order the split by values in Dashboards

p_devulapalli — Mon, 09 Sep 2024 00:04:47 GMT

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

Re: order the split by values in Dashboards

calfano — Mon, 09 Sep 2024 12:42:21 GMT

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?

Re: order the split by values in Dashboards

p_devulapalli — Tue, 10 Sep 2024 00:28:52 GMT

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

Re: order the split by values in Dashboards

Fin_Ubels — Tue, 10 Sep 2024 01:54:10 GMT

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.