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
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.
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?
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.
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?
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:
Looks good to me- glad Chris was able to help you work through it!