I have a scenario I'm trying to solve. I have one column with timestamps for when someone walks into a "room" and another column when someone walks out. I need to be able to calculate how many ppl are in the room at any given moment. I have connected a master calendar to the set-up.
A Timestamp = 1 event. Several events occur per day. I was thinking of keeping it simple and calculate the net number of events per day.
Therefore,
I need to calculate the accumulated number of events up-to the day I choose in the calender and I need it to change automatically when day is changed in the calender.
