ISO Week Problem with order or month split

[Anonymous]

Hi All,

I have the following problems since I work with ISO calendar weeks:
- In the calendar hierarchy during a drilldown I cannot influence the sorting of the weeks --> calendar week 53 in January is always displayed last
- I could create an assistant column so that I can sort a specially created column "Year-Month-Week" --> The problem is that data are separated which are in the same week but not in the same month

--> How can I solve one of the two problems?
1. wrong sorting of the calendar weeks
2. calendar weeks with the same number but in different months are not separated

Best thanks for all suggestions, below is the link to the data.

Dataset: https://we.tl/t-r2G6UgxvpH

[lbendlin]

First thing you want to do is correct your data model

Next you want to mark your Kalender table as a date table

Then replace the hierarchy with your "Year-Month-Week" column that you have already sorted by the hidden week number column as you did in the second chart.

By the way - what's the problem with how week 49 is displayed?

[Anonymous]

Thank you for these initial tips.

My mistake, I unfortunately forgot to insert the image in the post. The problem with week 49 is that it is displayed separately. One date is in week 49 in November and one in December but I want all dates of the same week displayed together.

The improvements that you have suggested do not solve this problem yet...

[lbendlin]

The week has to split up as it is present in separate months.  If you want it to show combined then you need to create a separate composite key Year-Week  (removing the Month)

[Anonymous]

In this case, I would have the same problem again in January that week 53 would be sorted incorrectly in January. Since I can no longer sort the "year-week" column by the hidden week number column.

[Proday83]

Hi there @Anonymous , I know that im more than year late, but if you are working with ISO (week) Format, how can be possible that you have week 53?

[lbendlin · Accepted solution]

You have two separate requirements, and need to solve them in two separate ways - as you do already with your two visuals.

You cannot combine these into a single solution. They have to stay separate.