Hi friends! Hope you're all hanging in there
As we are considering a wide variety of ways to put on a concert (if that's ever possible), we are trying to look at data of our patrons to see how many tickets are being purchased at any one time. I'm trying to build a dashboard that would show ranges of tickets purchases (1-3 tix per concert, 4-6 tix per concert, etc) and the unique households that make up those numbers.
I'm not exactly sure how to pinpoint that information in Analytics, if there even is a way.
Ideally, the rows would be season to separate out our different product lines, and the columns would be the ticket ranges. I think I'm getting lost in how to basically take an average, and then use the average to create the groupings, if that makes sense.
Thanks in advance!
The concepts you need are Filtered Values and Bucketing.
https://www.tessituranetwork.com/en/Items/Videos/Webinars/2019/Tessitura_Analytics_Skills