Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Comparing current date against the average of last same four days

gonzalos1167153
Level 2
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
jantzen_belliston-Adobe
Correct answer by
Community Manager
Community Manager

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
gonzalos1167153
Level 2
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

jantzen_belliston-Adobe
Correct answer by
Community Manager
Community Manager

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