Hello!
Looking for recommendations on the best way to look at STBs that purchased tickets to multiple productions. Ultimately, I'd like to be able to see how many constituents purchased tickets to 3 perfs, 4 perfs, 5 perfs etc. over the course of the season. Then, I'd like to save each as a list so that I can use them in an extraction.
Thanks!
Michelle
I set up a column chart to show me how many constituents were going to 1, 2, 3, 4, 5, 6+ concerts with the following formula as a value, and just adjusting the performance ID = 1 for each valueSUM ( [Constituent ID] , IF ( COUNT ( [Performance ID]) = 1 , 1 , NULL ) )The dashboard was filtered to a specific production season, but you could filter it to a specific season I would think.
Cheers, N
Thanks! I will definitely give this a try.
Hi Nicola - I set up a very similar chart (identical formula actually, just as a pivot table). We're also hoping to be able to identify the # of tickets for each category, and the $ revenue. So for example, 11,740 people bought tickets to 1 musical theater production -- but how many tickets is that and how much money? Have you tried to do anything like this and found success?
I've tried a Jump To dashboard, but it doesn't jump to information for just that group of 11,740 buyers it has information for all MT ticket buyers. The only thing I can think of is turning off each number sequentially and pulling the Jump To ticket and dollar data into Excel-- I'm going to have to enter the data into Excel to do % calculations (I'm fairly sure), but I'd love a slightly less manual solution to actually get the data.
Hi Dorothy,
You can get these other values by altering the formula to return the desired value in place of "1".
For example, # of Tickets:
SUM ( [Constituent ID] , IF ( COUNT ( [Performance ID]) = 1 , [Total Ticket Count] , NULL ) )
For $ revenue:
SUM ( [Constituent ID] , IF ( COUNT ( [Performance ID]) = 1 , [Total Ticket Paid Amount] , NULL ) )
Thank you Chris!! This worked perfectly, and I have all the info I need in my dashboard now. I appreciate this!