Calculate availability in per cent


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!

1 Like