I am trying to replicate a report we put together in Excel weekly that tracks a running sum of single ticket sales by production season against 3 different groupings - average sales, low (turtles) and high (ponies). All of the data for the comparators was pulled out of T-Stats and we pull the weekly data for performances within the next 8 weeks out of T-Stats, too. We then hand enter that info into excel and convert that pivot table into a line chart. Here is a screen shot of the pivot table and line chart from Excel:
It would be wonderful if I could put together a widget in Analytics to track upcoming performances in this same way but I am getting stuck because I can't figure out how to create custom groupings of performances to track ponies, average and turtles separately (and averages isn't technically the average, I toss out a few outliers) nor how to track against each upcoming production season separately. In the line chart in Analytics you can only break by one unique item. Though you can filter that item I can choose one production season or a grouping of production seasons but not several groupings of production seasons.
Even in pivot table form, if you filter prod seasons anywhere it affects that measure everywhere, it isn't possible to add two instances of prod season in columns for example and filter them separately.
We are RMA users and sales curves are easy enough to use there to track individual production seasons but even in RMA you can track against one forecast (average for example) but not several forecasts to split the 3 comparator lines.
Is there some work around I'm missing here?
Thanks,
Amy
Amy,
I’m not sure exactly what you are trying to do but if you want a different column for each production season you select try using the Text function in the Column filter.
Thanks, Terry! I didn't know that was an option, that is helpful. Now I just need to figure out how to create those comparator columns, too that contain a mix of prod seasons.
Check out this latest video. It think it might help you.
https://www.tessituranetwork.com/Items/Videos/Webinars/2019/Tessitura_Analytics_Skills
Here's the topics discussed:
Thanks, Terry and Cole. That gets me closer and would work fine if it was just a pivot table but when I move the pivot into a line chart the buckets aren't working quite right.
It either puts the graphs side by side in columns:
And you can't break by a formula so if I break by prod season it unselects one of my buckets (or more, down to just one bucket).
Hi Amy. It's the 2x RSUMs that always do it for me. I went to the Break by Custom Field for that reason. I'll give it a try over the weekend and see if I can come up with something. (Pesky shows are getting in the way).
I think that RSUMs are severely limited in a line graph. I'd love to have an RSUM hockey stick graph (contributions, ticket sales etc) with a Goal amount displayed. The RSUM always breaks the formula. Same with aggregations.