I have the following scenario:
- I collect standardized metrics for various separate sub-systems (each set of metrics is in a panel in some dashboard, e.g. one panel has 3 queries and 2 transformed results that use those 3 queries - for a total of 5 metrics)
- I want to then create aggregate metrics by combining the previous set of metrics (ideally as a weighted average, but just average is ok too)
How do I do that?
What I tried so far is to create library panels to be able to import individual panels in the dashboard where I want to create higher-level aggregate metrics. I’ve discovered that I can use the “–Dashboard–” data source only once (for 1 panel only). My plan was to use the metrics in the library panels and apply a Transformation to the metrics (e.g. average) to compute the higher-level metric but as I discovered I can use “–Dashboard–” source only once.
Any tips how my scenario can be implemented? I’d like to avoid copy-pasting the original metrics in each aggregated dashboard because I’ll have many of them.