Hello!
I've run into a problem with tracking our "Running Sales % to Goal by Days to Closing". This is a new dashboard widget for us. Our new Managing Director used it at his previous theatre. But- it's not working for us. Here is how it's looking now.
I think the problem is- we enter our "Budget" at a per performance level. So- let's say we want to make $100 on our run of "Example Play" over 50 performances. We would enter $2 as the budget in production elements -> performance. Where his previous theatre would enter $100 on each performance.
I think that the "Order Days Prior To Closing" tool is skipping days where there were no sales for a given performance. So it's also not pulling in the budget from those performances either-- making the budget change every day.
Note- we're also using a budget formula I believe my predecessor Katie got from Chris Wallingford.
sum ( [Performance ID] , max ( [Budget Amount] ) )
I pulled a pivot table that shows the problem from a different angle. https://drive.google.com/file/d/1j3FllhGVll8t4xPBdp652CYDNicMk9gi/view?usp=sharing
Help?
Hey Mike!
If you're looking at % to goal, wouldn't you want to use a running sum? So my % to goal formula looks like this:RSUM ( [Total Ticket Paid/Reserved Count] )/SUM ( ( [Total Ticket Paid/Reserved Count] , all ( [Order Days Prior to Opening] ) ) )