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?
So I think I fixed it. Instead of "Membership Level" I changed my parameter to "Current Membership Level" and it worked.
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