Comparing current date against the average of last same four days

Question

I am trying to use this comparison as a baseline for my daily site check. Does anyone know how to create a segment that displays (Avg (same last four days)) -

Current date Monday / AVG "last four mondays" > (Monday1, Monday 2, Monday , Monday4 )/4)

Ideally, i would like to see a calculated metric that displasy the percentage change between current day and the baseline shown above (also the "up to the hour" capability will be needed to have a fair comparison.

Thanks

-Gonzalo

jantzen_b · Accepted Answer

Since this is an older post, I'm assuming you've solved this issue. Incase others find this post, I'll post the link to the documentation below:

https://experienceleague.adobe.com/docs/analytics/analyze/analysis-workspace/components/calendar-date-ranges/time-comparison.html?lang=en#analysis-workspace

gonzalos1167153 · Answer

I have made some improvements since I posted the above question. See screen shot for daily comparison.

Then, i created an hourly view that compares today against previous same day. I used hour of the day (time parting) but unfortunately you can't order by Desc or manually arrange as long as the dimension is on the Y axis. Any thought on this?

Also, it would be nice to have a function that filter up to the hour

Sign up

Login with SSO

Login to the community

Login with SSO