Anyone have a recipe for determining the percent of first time ticketbuyers at a given show? I've macguyvered something together out of three separate widgets but am sure there must be a cleaner way.
What I have at the moment is a widget counting total constituent IDs for the production season; then a second widget filtered for records with that show as the First Performance Name; and then a third widget where I literally duplicated the second widget and then divided by the numerical value in the first widget - so obviously it's not responsive. So, question number 1: how can I fix my third widget, and/or condense these into a single widget that will tell me the total number of constituents, the number for whom this is their first show, and the percentage for whom this is their first show?
My second question is, how can I then expand this from one show to a full season, or multiple seasons? I want to get a season and multi-season average for the percent of new vs returning ticketbuyers so that I have something to compare each individual production against.
Thanks in advance for any suggestions!
This sounds like you need to use a "SUMIF" and maybe a Group By. If the concepts below don't get you there, look for posts by Chris Wallingford.