Hello
I’m not sure if this is a valid forum post, if not please remove.
I am very new to Grafana and I’m using it to monitor my smart home sensors. At the moment I am trying to create a pie chart that displays how much time a contact sensor has been closed compared to open.
How can I possibly set this up in a pie chart? The only thing I’ve managed to do so far is to display if it is open OR closed in the pie chart, which does not really help me 
I’m running InfluxDB and the contact sensors logs 0 and 1 for open/close.
Any help is much appriciated.