Yesterday compared to Yesterday 1 Year ago (Fiscal Year/Week Comparison) | Community
Skip to main content
Level 2
June 7, 2022
Question

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

  • June 7, 2022
  • 1 reply
  • 663 views

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!

 

 

 

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

1 reply

Level 4
June 10, 2022

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