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
There might be an easier way, but what about using Nathanael Pearson's custom filter idea? You could make the filter performance date, click Advanced, and then change the "last" section to another "from/to". It could hypothetically only include those with 2 dates.
"I've used a custom Perf Date filter many times before"
{ "and": [ { "from": "2023-07-12", "to": "2023-12-31" }, { "last": { "count": 366, "offset": 1 } } ], "custom": true }For example, here is a 3 date version.{"and": [ { "from": "2023-07-12", "to": "2023-07-12" }, { "from": "2023-07-26", "to": "2023-07-26" }, { "from": "2023-08-09", "to": "2023-08-09" } ],"custom": true}I tried it in Analytics and the filter did not throw an error, but I didn't have any data matching those criteria; so, I can't confirm it works.
Thanks, Neil! This makes sense. I will give it a go.
I've tried using this filter under filters and on the value itself and I'm either getting every ticket for the event or no tickets. Should it be in a value like this:([Total Ticket Count], [Days in Date])
or (SUM ( [Total Ticket Count]), [Days in Date])
Or should it be a filter in the filters panel?
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))