Hello! I hope someone can help point me in the right direction. I've been asked to provide some historical stats about our patrons. It seems I should be able to accomplish this with a dashboard- but I'm honestly not sure where to start with each widget.
1 - How many single ticket buyers (not subscribers) saw more than 1 production last year? In 2018/19?
2- How many single ticket buyers (not subscribers) saw more than 1 repertory production in the same week last year? In 2018/19?
3 - Many of our patrons live here seasonally. How many of our patrons are here (or have an active address) in June? July? August? September? Also, these numbers should be broken down by subscribers vs single ticket buyers.
Here's a screenshot of my widget that would answer the first question. You would just need to add a filter of price type category to filter out subscribers (or perhaps another filter type if you have your subs flagged in some other way.)
Thank you! Can you talk me through the formula a bit? So, is a sum of people who saw 1 unique performance and another? I don't understand the "=1,1,0" part. Sorry-- this is all kind of Greek to me.
It is basically saying, if the number of unique performances = 1, then return a 1, if not return a 0. This is all wrapped up in a Sum function that groups by constituent id. It is a method to count how many of thing match a situation. The concept is called bucketing. In Kanani's example, the column that is 2, Kanani changed the one part to = 2 instead of = 1.
Got it! Thank you!