I am creating a Dashboard for a Programs Coordinator to see how many of our major donors (Premier Level members) come to her Sunday Music and Chopin concerts.
I am using a Pivot table and have all of my rows/values/columns correct:Row - Production SeasonRow - Constituent Display NameValue - Attended CountColumn - Membership Level
I filtered my widget to only show me the Sunday Music and Chopin Production Seasons, which worked perfect.
I am stuck on the membership level aspect. For some reason, its listing everyone as (none), even the people who I know have memberships! So instead of putting the Attended Count in the correct column based on Membership level, its keeping them all in the (none) column. Once I added the Production Season filter, it also filtered down the types of Membership Levels (only 3 are listed instead of our 12, and its the 3 that I know are the member levels coming to these concerts). So the widget knows which membership levels are attached to those performances, its just not associating the attendance with them.
Why is it doing that? And how do I fix it?
Is this possibly a v16 defect?
Is it possible that they were a member at the time of the performance but aren't now? Memberships are so funky in Tessitura when you try to look at historical data. My first thought is that it is pulling current membership info and not what membership level they might have had at the time of the performance.
Nope, they are all current members. I checked a couple of their records just to be sure. And very few of our members change levels once they are there.
That is weird. Just to be sure, does this not happen if you use Membership Level as a row and not a column?
Just tried it on Row and its doing the same thing.
So I think I fixed it. Instead of "Membership Level" I changed my parameter to "Current Membership Level" and it worked.
Interesting: well, it's not a column/break specific bug then. Now what happens if you turn off the "Production Season" row? Do people sort properly into their membership levels then?
Hi Chelsea,
Glad you found the constituent elements for current membership information are working for you. To close the loop on the other Seats and Tickets membership fields. They are specifically present for reporting on Membership Scans and are not populated on Tickets. E.g.
Membership Level: For membership admission scans, the name of the membership level recorded for the scan.
In the SEAT & TICKET DETAILS dimension on this help page: https://docs.tessitura.com/Help_System_v160/Tessitura-Analytics/Data-Dictionary/Seats-and-Tickets-Cube.htm