Hello Tessitura community,
I am just starting to use Analytics to produce line graphs tracking our our marketing campaigns per production, modelling from the Production Sales default dashboards.
Does anyone know if it's possible to add a target line into these graphs? I imagine we might have to use campaign goals in order to do this...
Also, how can I transform a regular line graph to a cumulative one?
Thanks!
Krista
Hi Krista,
There was a bit of work on this kind of output in this post:
(+) Rolling Sales as they approach budget goal - Reporting & Analytics - Forums - Tessitura Network
The original post called for Performance Budget as the target. The challenge we ran into was that not all performances were represented in any given week, so we had to filter the "Target" formula to look at a specific week in which all performances have data, and then render the value from that week across all weeks.
If you use the Campaign Goal Amount instead of Performance Budget Amount, then the formula will change slightly to be more like:
MAX ( [Order Weeks Prior to Performance] , SUM ( [Campaign ID] , [Campaign Goal Amount] ))
Where the [Order Weeks Prior to Performance] (or whichever relative milestone anchor you've chosen) is set as a Filter, and using a Values type filter, set it "= 0".
As for the cumulative value, you might derive this from that other post, but check out the Running Sums section of this webinar:
Take Your Tessitura Analytics Skills to the Next Level (tessituranetwork.com)
Best,Chris