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?