Hello! Apologies if this has been asked and answered before, I scrolled through about a dozen pages of discussion and couldn't find it.
I'm trying to have one column in Analytics of total ticket sales by Performance (this I know how to do), and a second column that shows # tickets sold just in the prior week (need help here!).
Thanks in advance for your help!
-Ilana Barker
Here's my set-up:
So it's (Total Ticket Count , Price Type Category , Weeks in Date) I am filtering by price type category so it only shows my single tickets but if you are looking for all tickets you just wouldn't put that into your formula. And then you filter your order date to weeks and select last week.
Genius, thank you so so much! Also for the quick reply. :-)
Hi Madeline Dummerth (Past Member) I'm curious about what the date range is specifically for the Weeks in Date when you filter it by week. Is it the prior Mon-Sun? The prior Sun-Sat? Or the prior 7 days? I'm going crazy trying to compare it to exported Reports and choosing all different date ranges, but nothing is lining up 100%.
Second question - I tried applying the same methodology to get Days in Date to have a separate Analytics report that only shows sales from the prior day, but I'm having trouble getting it to work. Any tips?
Thanks so much :-)
Hey there - in our environment (I think it's like that for everyone unless you change it) the prior week is Mon-Sun! One of the challenges that we have with matching up reports is that if a return/exchange happened this week it will still be reflected in last week because that was its order date.
For prior day sales, I use the same methodology and select Days and then Yesterday as my filter. If you are looking to filter an entire dashboard like that you can do the same thing. Select order date > days > time frame > yesterday.
Let me know if that helps!
Yes, thank you!