Expand my Community achievements bar.

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

 

1 Reply

Avatar

Level 4

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

 

Vinoth1991_1-1654852947920.png