Okay...I am getting better at Analytics formulas, but I am stuck on one that I feel like should be very simple. Looking to y'all Analytics experts for some guidance!
There is "Last 7 Days"
{ "last": { "count": 7, "offset": 0 }}
And there is next 7 Days:
{ "next": { "count": 7, "offset": 1 }}
But how do I do both. I need a range with "today" in the middle. I feel like it should just be an AND. Either I am way off or I just can't seem to get the formatting correct.
I appreciate any help,
-Mark
Hi Mark,
Pick either one, set the count to 14 and the offset to +/- 7.
last 14 days with offset 7 (starting 7 days from now, the last 14 days)
or
next 14 days with offset -7 (starting 7 days ago, the next 14 days)
Thank you Chris! Makes sense...I had just never dived in to this piece before!! Appreciate the lesson.