topic Re: Dashboard - keep the colors for related data between panels in Dashboards & Visualizations

Is there any easy way to keep the colors for the same SQL statements/hashes between the two panels?

damucka — Mon, 21 Mar 2022 19:00:08 GMT

Hello,

We have several cases, where we relate the data between panels. On the example screenshots below, we have:

1/ Chart with the number of database threads in time, and the sum of threads per time unit involved in the execution of the particular SQL statement (SQL hash) - represented by the different colors:

2/ Pie chart showing the portion of the particular SQL statement / hash in the given time span:

Is there any easy way to keep the colors for the same SQL statements/hashes between the two panels?

Kind Regards, Kamil

Re: Dashboard - keep the colors for related data between panels

ITWhisperer — Mon, 21 Mar 2022 13:02:36 GMT

Apply some sort of sort so that the series (names) are in the same order.

Re: Dashboard - keep the colors for related data between panels

damucka — Mon, 21 Mar 2022 13:44:06 GMT

Unfortunately even after sorting both the same order, see the screenshot below, the colors assigned to both panels are different:

Re: Dashboard - keep the colors for related data between panels

ITWhisperer — Mon, 21 Mar 2022 13:48:06 GMT

That's because they aren't sorted in the same order (you can see that from the legends) - how have you done the sorting?

Re: Dashboard - keep the colors for related data between panels

damucka — Mon, 21 Mar 2022 14:38:33 GMT

You are right of course.

I managed to match it, but now the issue is, that the stacked column chart displays like 9 different SQL hashes + others and the pie chart way more of them + others. The not quite nice consequence is, that the color for "others" does not match.

Would you know a chart option for both, stacked column and pie chart to restrict the number of displayed values say to 7 + "others"?

I could not find it in the visualization options, so I guess this is some more advanced parameter I would use in the xml.

Re: Dashboard - keep the colors for related data between panels

ITWhisperer — Mon, 21 Mar 2022 14:48:56 GMT

Probably the way to do this is to implement the "other" stat as part of the SPL, that way you have control - so long as it was under the number of series supported by the pie chart.