Hello,
I am new to Analytics and I am tasked with creating a dashboard to see progress to goal for our shows. I would appreciate any guidance as to where to look for the information in Analytics.
Thank you
Asma
Hi, we use the budget amount in performances and set up a simple formula that tracks revenue to budget to measure progress.
I've also run into the situation Heath has described, so if you do have different prod seasons in the same widget it can cause a discrepancy.
Hi Michael. I am really new to using analytics and do need to do something similar to what you are showing per performance tracking revenue to goal/budget. For your Revenue to Budget column do you also use the "Total Budget Amount" under Performance Detail but then apply a formula? May I ask what formula? Do any of your other columns have a formula? Thanks!
Hi Christina,
For my revenue to budget, it is a formula taking the total ticket paid amount / the total budget amount.
For both the ticket paid amount and budget amount, you do need to hover over each select Sum, so you get the 'total ticket paid', and 'total budget amount'. Otherwise, it will most likely through an error.
Hope this helps!
Michael Thank you so much! I think I got it working