• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 54 views
  • Users 0 members are here
Related

Postshow Attendance compared to Show Attendance

Savannah Cathers (Past Member)
$organization

Hi Y'all, 

If there is documentation for this somewhere, just point me in the right direction, but I've given up my search. 

I want to compare the number of constituents that attended a show to the number that attended the post-show talkback -- ideally within the same pivot table. I have already isolated the post-show constituents into a list, and I can pull that into analytics. However, I am curious if I can compare the two attendance rates in the same widget. 

Is a Multi-Pass Aggregation the way to do this? It feels like it is, but I cannot get the formula right. Here is what I have now:

Sum([Constituent ID], IF ([Lists2] = 1, 1, 0)) 

Any and all help is appreciated! Thank you so much :) 

Parents
  • $organization

    Hi Savannah,

    If you do this in a pivot table, you'll need something on Rows before the Values will appear. Presumably that would be the Show name, and I'm also assuming that the widget is filtered to just the one show, and that all post-show talkback attendees are also show attendees. With that though, you would want to use a Filtered Value Formula for a unique count of Constituent ID, filtered on Lists.

    ( [# unique Constituent ID] , [Lists] )

    Where the Lists field is filtered to the List ID per the linked help page. 

    Best,
    Chris

Reply
  • $organization

    Hi Savannah,

    If you do this in a pivot table, you'll need something on Rows before the Values will appear. Presumably that would be the Show name, and I'm also assuming that the widget is filtered to just the one show, and that all post-show talkback attendees are also show attendees. With that though, you would want to use a Filtered Value Formula for a unique count of Constituent ID, filtered on Lists.

    ( [# unique Constituent ID] , [Lists] )

    Where the Lists field is filtered to the List ID per the linked help page. 

    Best,
    Chris

Children