I am using google sheets to automatically track how many times the garage doors are opened through IFFFT.
I have ‘Garage door’ and ‘Third stall’, the 2 different variables (doors) to track.
I am currently calculating the total cycles in column F, but I would like to track how often each one is opened/closed every day, on average.
I feel like I’m close with the :AVERAGEIF query, but I can’t quite get it right.

I can’t seem to figure out a formula to make sure to check the Time column and separate it out each day for each door, then create a rolling average of how many times each door is opened/closed each day.

How might I calculate each one independently with a rolling average in column G?

Thank you so much!