Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Comparing current date against the average of last same four days

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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-dat...

View solution in original post

2 Replies

Avatar

Level 2

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

Avatar

Correct answer by
Level 10

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-dat...