Counting uptime of a device

Hi out there,

I have a device which reports its status as an integer value (10 for “running”, 1 for “stopping”, 2 for “starting”, 0 for “down”) into influxdb.
Is there any way to display the percentage of time this value was “10” with Grafana over, say, last week or last month?
Thanks in advance
Best regards


Of course you can, i think the pie chart is what you are looking for :

Hope it helps.

Good Luck