Hi,
I'm trying to build a dashboard to show crossover of audiences for different strands of our classical season. I have saved a list for each strand.
I need a formula to count a constituent Id if it is included in more than one list, so some variation of sum if [constituent id] [list A] and [list B]
Any ideas?
Thanks
Hi Ogo,
When you put in the List Filter it should give you the option of adding multiple lists, and in the upper right corner you can choose if you want to filter based on folks in one list OR the other, or based on folks in one list AND the other:
There is a post here that might be helpful: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_marketing-9/26336/crossover-sales-report/73384?_ga=2.102881541.461565057.1663600516-714990149.1662006053
I think the easiest option to try might be filtering a widget to one of the lists, then filtering the categories field section to the prod season IDs or performance IDs you want to count crossover for.
Alternatively, you could create a third list where the criteria are "has [list 1]" AND "has [list 2]" to see crossover without a dashboard. The third list could be pulled into a dashboard afterward.
How did I forget about this?! Thank you
Thanks this is useful info!