• Replies 6 replies
  • Subscribers 700 subscribers
  • Views 112 views
  • Users 0 members are here
Options
Related

Count of constituents who attended more than one performance in a production season

Anne M Robichaux
$organization

After nearly three weeks on vacation, my body is back but my brain has decided it needs a bit more time. :-) I know we've covered this before, but I can't find the thread. I've been asked for a count of people who attended a special exhibition more than one over its run -- a constituent count would suffice, but a ticket count would be great too. 

Thanks!
Anne Robichaux

Parents
  • $organization

    One of my favorite formula variants!

    SUM ( [Constituent ID] ,


    IF ( [Attended Count] > 1 , 1 , NULL ) 

    )

    You could then filter the dashboard by' that Value > 0' and 'the Exhibition Prod Season' that you want. Then, have another Value of 'Ticket Count' to round things out.

  • $organization in reply to Nathanael Pearson

    I had a feeling that you would have this set up, Nate! Thanks!

    That makes total sense, but I'm getting an error message. Both Constituent ID and  Attended count are set to "All"  -- is that right?

  • $organization in reply to Anne M Robichaux

    I changed Attended Count to Count All and I think that has fixed it, but the filter isn't affecting the Attended Count value -- that's the total for the exhibition.

  • $organization in reply to Anne M Robichaux

    Oh, I think I'd assumed that the 'Rows' would be 'Constituent ID' or 'Display Name'. In this case, the '# of constituents' value is correct, but filtering the table by that Value doesn't affect anything. That filter says 'show me the Production Season where there is more than 1 constituent who attended more than once', which is the same as saying nothing at all.

    We'll need a way with our values to say "how many people attended more than once, and what was the total attendance of those people?"

    The first thing that jumps into my head is to keep the filter for Prod Season, but change the row to 'Constituent Display Name' or 'Constituent ID'. That way, the '# of constituents' value (combined with the filter you based off it) would weed out anyone who didn't attend more than once. Then, your 'Total Attended Count' value would pull in the attendance count for those multiple attenders, because the '>= 1' filter takes out anyone who didn't attend more than once.

    Does that make sense?

  • $organization in reply to Nathanael Pearson

    Just as I was starting to read your reply, I jumped into a Museum, Zoos and Aquariums meeting that Chris Wallingford was at to talk through dashboard issues! Serendipity! We were able to talk through my widget and got it working. Here's what we came up with:

Reply Children