Hi,
Working on a Dashboard to display a bunch of fun stats about our DYO (Design-Your-Own) packages where patrons can select 3-6 unique productions. I am able to break out the Num of Unique Productions per order (each order on it's own line), but have not been successful in finding a way to show the avg num of unique productions selected overall this season for DYOs.
Has anyone done anything like this before?
Thank you,Dani
Hi Dani,
Not sure if this gets at the averages you are looking for, but I usually make pie charts to view by package size. In this example, we are assuming that package size means 3 unique productions, though theoretically it could be three unique performances (I don't think that's likely). Including a screenshot of the parameters and the filters here if that is helpful for you!
Hi Jen,Thank you for your suggestion! It is very interesting and I added it to my report.
I was trying to find a way to report on the overall average number of unique performances per order. So for example, that number is currently 3.22. Patrons are selecting on average 3.22 shows per order....and I just figured it out.
That AVG() function as you have it is going to take the number of unique production seasons and divide by the number of rows in the data (tickets and price layers). I don't know what filters and row groupings you have in place, but if you want to guarantee that this is measured per order, you might need Multi-Pass Aggregation (tessitura.com) to first create per order subtotals for the count of unique production seasons, and then take the average of that.
AVG( [Order ID] , [# unique Production Season ID] )
Thank you, I added your suggestion and got the same 3.22 productions per order.