I feel like we've talked about this, but I can't find a post. And I also feel like this is pretty basic, but my brain isn't doing bucketing today. We have a three day event coming up and people register for each day individually (a pricing rule gives them a discount if they register for all three, but it's still the same three perfs). I'd like to set up a widget to show how many people are registered for Friday only, Fri/Sat, Sat only, Sat/Sun, Fri-Sun. Or multiple widgets, if necessary. I can easily get a count of who is registered for each day, but I need help with the combinations -- Fri/Sat, Sat/Sun, and Fri-Sun. Thank you!
Anne Robichaux
Thanks to Christine Wingenfeld for figuring this out in this morning's analytic Coffee! meeting!
In case it helps anyone else, here's what we came up with:
COUNT ([Constituent ID],IF (([Total Ticket Count],[NOAF Fri] ) >0 AND ISNULL (([Total Ticket Count],[NOAF Sat Sun])), MAX([Constituent ID]), NULL))
COUNT ([Constituent ID],IF (([Total Ticket Count],[NOAF Friday] )>0 AND ([Total Ticket Count],[NOAF Sat] )>0 AND ISNULL (([Total Ticket Count],[NOAF Sun])), MAX([Constituent ID]), NULL))
COUNT ([Constituent ID],IF (([Total Ticket Count],[NOAF Sat] )>0 AND ([Total Ticket Count],[NOAF Sun] )>0 AND ISNULL (([Total Ticket Count],[NOAF Fri])), MAX([Constituent ID]), NULL))
COUNT ([Constituent ID],IF (([Total Ticket Count],[NOAF Sat] )>0 AND ([Total Ticket Count],[NOAF Sun] )>0 AND ([Total Ticket Count],[NOAF Fri])>0, MAX([Constituent ID]), NULL))