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?
Hi Bridget,
We've been having a discussion for something similar over on the analytic Coffee forums:https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/30795/sales-pacing-chart---inputting-goals-budgets
There is a relatively easy way to insert a target line if you add a value and in the formula just type in your goal amount. I learned this somewhere on the forums, but here's the general idea:
I hope that helps!
- Christine
This is the formula we were able to come up with:
( [# of unique Performance Date and Code Short] , [Days in Date]) * [Max Budget Amount]
This is worked perfectly, thank you!!