Hi All!
I’m trying to build a dashboard for single purchasers (constituents that have only seen one show) and what that show is, in addition to some other info. Its pretty easy to get a list of the constituents that meet this constraint (table 2 in the below photo) but when you add in “performance”, most performances have a value of “1” now so the list becomes almost every constituent record we have. I thought it would be an easy fix to just filter by the Subtotal, but I can’t seem to figure out a way to filter by the subtotal.
In addition, Chris Cuhel created a list where "Ticket History Unique Perfs = 1", and this gave a different list (labeled 3 in the photos below), but was still showing constituents that saw more than 1 show. The problem is definitely when you add "Performance" as a row, but that's pretty necessary to make this data useful.
I know i could just combine the two tables in Excel, but i'd love for the report to live only in Analytics as this will be a constantly evolving report.
Thanks in advance for any thoughts or suggestions!
I'm interested in seeing what folks have to say about this one!