How can I get the total time a component spent in particular value in the time range?

I have action data sent from a device (on / off times) and I want to know in the current time range - how much time the device was on / off in total…

what’s the best way to do that and which panel would you recommend for this ?


There is no way to do this currently in any time series database query language (that we know) and Grafana does not do any metrics processing (at this point, we want to add it).

If you use Graphite it’s possible to calculate a percentage for a particular value.

But this could be a new stat option in singlestat so please open a feature request in our github repo.