First of all, thank you all for your contributions. Although a previously silent member of this group, many of the topics have been useful to me in my work.
I'm trying to come up with a widget that will show how many operas from our 4 opera season, constituents have purchased. So I'm looking for how many bought 1, how many bought 2, how many bought 3, etc. Using some of the formulas in previous discussions, I've created a widget to show how many people bought single or multiple performances, but this doesn't allow for a single constituent having seen multiple performances of one title.
Any direction or thoughts would be much appreciated.
Very best,
Richard RussellGeneral DirectorSarasota Opera
Hi Richard,
In your bucketing formula, try [# unique Production Season ID] in place of [# unique Performance ID].
Thanks so much. That did the trick. I'm new at this and was getting the # of unique performances another way. This solved it.