Forum Discussion
ISO Week Problem with order or month split
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.
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...
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)
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.
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.
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?
