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.