Hi!
Is there a way to design a widget that splits all ticket buyers for a specific production into those who appear on a particular list v those who don't? I can get the data in a table which lists all the people on the list and can switch the filter to show all the other people who are on none, but I can't figure out how to simply come up with a yes/no solution. Ideally I'd love a pie chart that splits the total pool of ticket buyers into those who are on the list and those who aren't.
I'm trying to find out how many people who bought tickets to the production are subscribers to our e-news, so if there is a better way to do it I'd love to hear ideas! All I can think of is to use our current subscriber list as a filter.
Thanks!
Hi Tash,
something like this? Filter to 'contains this list ID' for the 1st value & then 'doesn't contain the same list ID' for the 2nd value. I did a quick check of numbers & seemed to look right.
Jo you're a genius! Thank you that worked a treat! It actually confirms the earlier number I was getting so I'm comforted that I was on the right track! Thanks!