Hello friends,
I’m attempting to make a chart that will show how many performances first-time patrons saw last season. This would be a bar chart (or a column chart) that would be broken by number of performances: 20 patrons saw 1 performance; 34 patrons saw 2; 55 saw 3; and so forth.
I was going to start by creating a list of first-timers from last season and use that as a widget filter.
But even if I wasn’t interested in whether they were first-timers or not, I’m stumped on what data to start with in my widget. I’m thinking I need to start with constituencies, but I don’t know how to go from that into number of performances per constituent.
Any tips?
Many thanks!
Hi Will, I've acquired the below from the forums somewhere (so thank you to whoever shared this in the first instance), but category has been setup as Constituent ID (value equal to or greater than 1), with values associated with count performance ID and number of unique constituent IDs. We then filter for a festival or season and works quite well - I assume the added filter of your list wouldn't be an issue.
Hope that helps
Ahh! Makes perfect sense. This is very helpful. Thanks a million!