Good Morning,
I created a list of patrons who purchased 3+ shows (non-sub tickets) and I get a list of 1,371 HH's. However, when I save it to a list I get 40,000....what am I doing wrong?
Overall Filters:
Season: 2017-18, 2018-19, and 2019-20 Broadway
Price Type Cateogry: Discount, Groups, Standard (excluded Season tickets)
Price Type: Excluded Standard Groups as we only want the single ticket type purchases
Created a Pivot table
Rows = CID
Values = # of Unique HH and # of Unique Production Seasons (greater or = to 3)
Season = 2017-18 Broadway
Created Jump to so I could save to a list. It says there are 1,371 HH, but when I start the process to save to a list, it gives me 40,000
Help :-)
Thanks Y'all!!!
Kimberly
Hi Kimberly,
I wonder if you're running into this:
When you jump to the _Constituents dashboard, the filter on Unique Production Seasons being >= 3 isn't coming through correctly. There might be a work around for this where instead of using the Unique Production Seasons value as a filter, create a Widget level filter on Constituent ID, using the Ranking type, include the TOP 5000 and use a formula like:
IF ( [# unique Production Season] >= 3 , [# unique Production Season] , NULL )
Here's a similar example from another recent thread:(+) Bottom 5? or 20? But with a minimum. - Discussions - Tessitura Analytics for Marketing and Ticketing Operations (TAMATO) - Tessitura Network
Because this is a Widget level filter and not a filter built off a Value, it should carry through to the _Constituents dashboard and filter it in the way that you expect.