Incomparability when using date comparison

Avatar

Avatar

patricks6774671

Avatar

patricks6774671

patricks6774671

15-10-2018

Hi all,

I'd like to have a comparison of my KPIs with last year for yesterday, last week and last month. I managed to do this for last week and last month with the default setting "This week/month last year to this date range" but cannot find the same setting for the yesterday last year comparison. I am aware of that I can set a custom date range but face the following problem by doing this: Due to the 4-5-4 calendar system, the year 2017 was a 53-week year, with January consisting of 5 weeks instead of the usually 4 weeks. According to the National Retail Federation (NRF), 53-week years are restated for comparability purposes (read here​ for further information). Unfortunately, the calendar used in Workspace is not restated so that when I want to compare yesterday, the 14th October, with yesterday last year, the target day would be the 8th October resulting in that those two days are incomparable.

1596283_pastedImage_3.png1596284_pastedImage_4.png

Strangely enough, when using the default setting of Adobe to compare last week of last year, the calendar seems restated and compares the correct week but when comparing last month of last year, the calendar seems not restated again.

1596286_pastedImage_5.png1596322_pastedImage_7.png

I hope my explanation was comprehensible and that you guys can help me with this.

Best regards,

Patrick

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Total Posts

(val/1000)?string[".0"]}K

Likes

458

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

(val/1000)?string[".0"]}K

Likes

458

Correct Answer

734
Gigazelle
Employee

29-10-2018

The 8th compares to the 14th because they are both the second week in October.

Other than creating another date dimension that offsets the date by one week, I don't know what to say. You'd then use the date dimension that works best with the previous date comparison.

Answers (1)

Answers (1)

Avatar

Avatar

patricks6774671

Avatar

patricks6774671

patricks6774671

30-10-2018

Ok but what about the fact that when I 'Compare time periods' -> 'This week last year to this date range', the restated calendar is used and when I compare with month the unrestated calendar is used.

Example: Let's say I want to compare last month with the last month of last year.

1610007_pastedImage_1.png

The time period here is Sep 2 2018 - Oct 6 2018. Now I add a time period column for last month of last year.

1610009_pastedImage_2.png 1610010_pastedImage_3.png

The period Aug 27 2017 - Sep 30 2017 is compared which is fine if using the unrestated calendar.

Now I want to do the same for last week.

1610006_pastedImage_0.png1610011_pastedImage_5.png

Time period here is Oct 21 2018 - Oct 27 2018 and the compared time period for last week last year is Oct 22 2017 - Oct 28 2017. If we now have a look on the unrestated calendar for October, we'll see that the third week of October is compared with the fourth week of October:

1610024_pastedImage_6.png

The period Oct 22 2017 - Oct 28 2017 would be fine though, according to the restated calendar:

1610025_pastedImage_7.png