Comparing current date against the average of last same four days | Community
Skip to main content
Level 2
August 26, 2016
Solved

Comparing current date against the average of last same four days

  • August 26, 2016
  • 2 replies
  • 1087 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by jantzen_b

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

2 replies

Level 2
September 2, 2016

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

jantzen_b
Adobe Employee
jantzen_bAdobe EmployeeAccepted solution
Adobe Employee
March 4, 2021

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