I have multiple series that report their response times every 5 minutes into Graphite. Whenever a system is not available, the reponse time 1 is returned. I would now like to use that data to calculate the overall availability in a Grafite gauge widget.
So here is what I would like to do
a count all data points reported
b count all data points with a value < 2 (= service unavailable)
c calculate uptime = a / (a - b) * 100
d display the value in the Grafite gauge widget
Is there a way to achieve this? Any help would be highly appreciated!