ISO week Year not comparing 1st week of 2025 to 2024 since the 1st week of 2025 started in 2024

[ibimon]

Hi.

I created a cumulative graph which is meant to compare weeks to previous year as they go on.
The problem is that week 1 of 2025 started on 20th of Dec.

So the graph shows 0 for week 1 of 2025, then for week 2 it shows week actual week 2 data without adding week 1, which in turn skews the result as weeks go on since we're missing week 1 data of 2025 in the graph.

Something to note is that the report I'm using has only from date which is always a Monday and a to date which is always a Sunday.

I have tried converting both into week year format via a calculated field, but I can't format it as a date, only as string. So in turn I can't use it as a dimension.

Has anyone come across a similar problem and know the fix or work around?

Thank you.

[ibimon · Accepted solution]

I have found the solution here.
My setup is a little different but it worked: