Patrons by # of concerts purchased last season


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!

Parents Reply Children
No Data