Hi, is it possible to aggregate a variable value in a graph? Like summarize/count/average. Or does this require analysis?

For example, we use a door sensor. Open door = 0, close door = 1. So using this door variable I would like to create a daily overview using the counting value of 0. How many times was the door open each day.
In SQL language, I’m looking for a graph option to show count(door_opening) where value = 0 group by day(timestamp).

I would appreciate any thoughts and ideas!

Thanks!
Vincent