Weekly order

[sheva]

Hi,

I have format weeks by " YYYY-MM" and now week 10 is causing problems. Order was just fine beore week 10: 2019-1, 2019-2, 2019-3... and now order is 2019-10, 2019-1, 2019-2, 2019-3...

Any help?

[PattemManohar · Accepted solution]

@sheva  Please add an another column as "SortKey" and use this as "Sort By Column" for the "WeekNum" field

SortKey = FORMAT([Date],"YYYYWW")

Before using SortKeyAfter using SortKey

[PattemManohar · Accepted solution]

@sheva  Please add an another column as "SortKey" and use this as "Sort By Column" for the "WeekNum" field

SortKey = FORMAT([Date],"YYYYWW")

Before using SortKeyAfter using SortKey

[sheva]

@PattemManohar Didn't get that working. Sould the type be text or number?

On the list order is as I want, but not in the graph.

[PattemManohar · Accepted solution]

@sheva Yes, you need to change the Data Type of sortkey (which is our calculated column) to "Whole Number"

[sheva]

It fixed first problem but made a second with visualization. I use that YYYY-MM format as filter.

[sheva]

@PattemManoharFor some reason it's working now, when I try it second time.:)