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
Apply some sort of sort so that the series (names) are in the same order.
Unfortunately even after sorting both the same order, see the screenshot below, the colors assigned to both panels are different:
That's because they aren't sorted in the same order (you can see that from the legends) - how have you done the sorting?
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.
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.
Apply some sort of sort so that the series (names) are in the same order.