New to Grafana - Pie chart help


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 :slight_smile:

I’m running InfluxDB and the contact sensors logs 0 and 1 for open/close.

Any help is much appriciated.