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?
Is this a "before image", Mike, or did you address the issue?
Curious if for the Value, whether Display Missing Values as Zeros is selected...
If so, maybe/hopefully deselecting and following this post will help...
(+) Joining Isolated Data-points, Removing Data Markers, Interpolating Last Point - Wiki - analytic Coffee! - Tessitura Network
It was not selected. The problem isn't happening on the Days to Closing widget. And it wasn't happening yesterday.
Would you try duplicating your Closing widget and editing it. Replace Order Days to Closing on the x-axis with Order Days from Opening, and then update the formula to use Order Days from Closing as well. If that corrects the problem, apply the changes, rename it, and remove the badly behaving Opening widget.
If that doesn't correct the problem, would you please open a support ticket and include an export of the dashboard for us to review?
Tessitura v15 Help System - Exporting a Dashboard (tessituranetwork.com)