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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Yesterday compared to Yesterday 1 Year ago (Fiscal Year/Week Comparison)

Avatar

Level 2

Hi,

I need to compare Yesterday to Yesterday 1 year ago, but in alignment with the fiscal week. So for example, if yesterday was 6/6/22 (Monday), I need to be able to compare that date to Yesterday 1 year ago, but in alignment with the fiscal week, which would be 6/7/21 (Monday). In this scenario, the Monday's compared line up for the same week, just Last Year compared to this Year. 

The problem is that I cannot use the "Date Range Builder" 365 (or 364) days back, because that same Monday 1st week of June 1 this year (6/6/22) could be on a different weekday of last year, which 6/6/21 fell on a Sunday. In this example, it would need to compare to 6/7/21, instead of 6/6/21. The 365 or 364 days back can constantly shift with a fiscal week.

Is there a way around this? The other problem is the "Date Range Builder" only lets you look at current date, so that make it more difficult. Any thoughts or a workaround?

These are my segments and metrics and dates used too (cannot share results because of privacy reasons).

Thanks!

skatofia_3-1654618842400.png

 

skatofia_2-1654618780766.png

 

skatofia_0-1654618534395.png

 

0 Replies

Avatar

Level 3

You can also choose current week  , did you try like this? click on current day to get multiple options

 

Vinoth1991_1-1654852947920.png