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
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.