Grafana Version: 9.3.2
I’m new to Grafana and Prometheus, so I may be missing something simple, but here’s what I have, and what I would like to make happen:
I have Prometheus instance using Blackbox Exporter to probe approximately 250 remote devices for their current status, what I end up with is a time series with some labels (Region, Customer, Site, ID) and a 0 for failed or a 1 for success.
I have managed to build a Gauge panel that queries by the selected Region, and has a Gauge for each Site label in the region. What I would like is for the Gauge max to be the count of IDs in that site, and the value to be the count of probe successes for the site.
I figured out how to get both numbers with 2 queries:
Success:
count by(sitename) (probe_success{regionname="$regions"}==1)
Total:
count by(sitename) (probe_success{regionname="$regions"})
But I haven’t been able to figure out a way to set the gauge max to Total. Instead max seems to be pegged to the highest value of any gauge in the query.
As a second feature, I would like the color thresholds to be dynamic as well: Base Red and Green if Success == Total.
Is this possible?
Thank you
Adam