Forum Discussion
Order Week Year Chronologically
Hi,
I have the following table:
I would like to order the field W Week Year chronologically, since when I add it to a visual appear in the following order. The calendar table contains dates for 2023 and 2024.
How can I order it chronologically? Thank you so much!
I guess you can use the sort by column with date
Hi EsterBR - thanks PabloVallejo12 for sharing your inputs,I just want to few points,
EsterBR select the column Weekyear and sort the column based on weeknumber and order will get automatically based on on
It works , please check .
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!your week year column is text type. try to change it to year(date)*100+weeknum(date)
then sorty the W week year column by week year column
3 Replies
I guess you can use the sort by column with date
Hi EsterBR - thanks PabloVallejo12 for sharing your inputs,I just want to few points,
EsterBR select the column Weekyear and sort the column based on weeknumber and order will get automatically based on on
It works , please check .
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!your week year column is text type. try to change it to year(date)*100+weeknum(date)
then sorty the W week year column by week year column