Subject: Creating an Overview Dashboard with Aggregated Status from Multiple Detailed Dashboards
Tags: dashboard prometheus #mathematical-expressions #aggregation #status-overview
Hello Grafana Community,
I’m relatively new to Grafana and have been tasked with creating an overview dashboard that aggregates status information from multiple existing detailed dashboards. I’d appreciate guidance on the best approach.
Requirement
I need to create a single overview dashboard that displays the “worst case” status from each existing detailed dashboard using gauges or similar visualizations.
Example scenario:
-
Dashboard A has 30+ panels monitoring CPU, RAM, network, etc.
-
Dashboard B has similar detailed monitoring panels
-
Overview dashboard should show one gauge per detailed dashboard
-
Each gauge should reflect the most critical threshold state (Green/Yellow/Red) from all panels in the corresponding detailed dashboard
-
Gauges should link back to their respective detailed dashboards
Current Approach
I’ve been experimenting with mathematical expressions to convert threshold states to numeric values:
($A > 50) + ($A > 70)
This produces:
-
0= Green (below warning threshold) -
1= Yellow (warning threshold exceeded) -
2= Red (critical threshold exceeded)
Problem
After creating 20+ mathematical expressions (one per panel), I need to find the maximum value to determine the overall status. However, I cannot use max($A, $B, $C, ...) with multiple variables in mathematical expressions.
Questions
-
Is there a way to aggregate multiple mathematical expression results using a max function in Grafana? I was expecting the math expressions to support a max fucntion but unfortunatley this does not seem to be the case.
-
Are there alternative approaches for creating status overview dashboards that don’t require modifying Prometheus exporters?
Any suggestions or alternative approaches would be greatly appreciated!
Thanks in advance for your help.