Hey, I'm trying to build a widget that will allow me to see our cumulative single ticket revenue for the performance on the Y and order weeks till closing on the X axis. That part was easy enough but I'd like to add a line indicating our single ticket goal so we can see how we are tracking toward budget. Is there a way to do this?
This is the formula we were able to come up with:
( [# of unique Performance Date and Code Short] , [Days in Date]) * [Max Budget Amount]