I am working on recreating one of our custom reports and there are two things I am having trouble with....
1. Our report sorts by production with the next production appearing first and past performances moving to the bottom. Is this possible in Tessitura Analytics?
2. We also do a percent of the budget so we can keep an eye on how close each show is to making budget. I am not sure how to go about this in analytics as I cannot do a formula on a row. I also cant figure out how to total the budget by production since the amount is added to each performance.
Any help would be greatly appreciated.
Thanks
Margaret
I'm having trouble getting the budget to show accurately on a line graph. I have a line graph that shows the running total of sales each day and I want to see it's progress towards the budget. It works fine when a show has a single performance, but does wacky things when there are mutliple peformances. Below is an example of the line chart. The budget for this performance is $1.01M, but the budget line is showing $744,000 at the end of the line. Ideally I'd like to show a "daily goal" that leads up to the final budget, but would be fine with just a straight line of the overall budget throughout. Any thoughts?
The concept you need is Multi-pass Aggregation.
What is a Multi-pass Aggregation Formula?
https://www.tessituranetwork.com/en/Items/Videos/Training/Analytics/taffy-october-2019
...starting at 9 minutes 45 seconds
Formula for the Secondary Value (an example of multi-pass aggregation):
SUM([Campaign ID]), MAX([Campaign Goal Amount]))-[Total Amount]