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,
I had a follow-up thought. The challenge in the linked post is that there's a potentially different Performance Budget Amount for every performance, and they need to be summed up. If you're limiting your results to a single production season, and all performances in that production season are tied to the same campaign, then that campaign IS represented in every week of you relative milestone. And given that, you can probably just use
MAX ( [Campaign Budget Amount] )
as your target formula.
Hi Chris,
The reference to the previous post was informative (starting to see the logic in the setup...) but I should have specified that we are looking for the # quantity of tickets paid target rather than the $ budget target. Currently we don't input this data into our ticketing builds, but I wonder if this needs to be inputted somewhere or whether it could pull from the number of seats made in the build?
At this stage we are looking at the individual performance level, and each performance will be under its own widget.
Let me know if you have any additional tips for this.
Thank you!
It the number of seats in the facility, or the number of seats of a given seat type in the facility, is an effective target, then something like these could work:
( SUM ([Seat Count]) , ALL ([Weeks Prior to Performance]) )
or
( SUM ([Seat Count]) , [Seat Type Filter] , ALL ([Weeks Prior to Performance]) )
When grouping that Seats and Tickets data by Weeks Prior to Performance, a simple SUM ([Seat Count]) will only return seats associated with the given week. The ALL() function will break out of the [Weeks...] grouping and return the sum across all weeks.
If a capacity count like above isn't quite right for your target, there are 2 other options. The first is hardcoding a value into the widget. Simply "Add" and new Value, click the fx button, and type the raw number you want as the target, and click OK. If however, you need something more dynamic that will allow you to enter targets in Tessitura (e.g. via Inventory Content field or a special System Table), and have them change in your dashboards to automatically reflect the performances on which you've filtered, then I can put you in touch with someone on our consulting team to quote and implement that small customization.
Cheers,Chris
With the raw value, sometimes we have a target number that is based on a calculation made by finance and it looks like this
The blue line is Rsum([Total Ticket Paid Count])
The orange line is just the target number in the formula field as Chris says
Orange line