Hello ,
I am looking to find how many households that bought tickets for multiple performances within a season, bought tickets for consecutive performance days vs. dates that were not consecutive?
For example... Household A bought 3 performances, that were on Feb 1, 2 and 3. Household B bought 3 performances but they were on Feb 1, Feb 10 and Feb 20. Of a grouping of HH, how many fall into the HH A category and how many HH fall into the B category?
I can't figure out how to do this, any ideas welcome!