I am trying to recreate this in Sisense. My Challenge is how do I count the total appointments in my system on a given day and then make sure that number never changes even though the state of appointments will change. for example:
On week 1 I counted 10 open appointments. 3 for this week, 5 for next week and 2 for the following week.
During the Week 1 the following happened, 3 appointments were marked as attended, 2 appointments for next week were canceled and we added 3 new appointments, one for next week and two for the following.
On week 2 I want to still show that we had 10 for last weeks snapshot, and that we have 8 open appointments as for right now.
I have attached some charts to show, hopefully, what I am trying to do.
Please sign in to leave a comment.