Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a chart sorting it by week but the problem is that I need to show the last weeks of the year then the 1st week of this year ..can any one help?
Can you please share sample
week number | value |
---|---|
52 (2017) | 80 |
1 (2018) | 90 |
2 (2018) | 100 |
Sort using YearWeek field rather than just Week... YearWeek will make sure that sorting is also based on Year field and not just week field
Create a new field in the script like this
(Year * 100) + Week as YearWeek
can you explain more
Create a new field like this
(Year * 100) + Week as YearWeek
and then may be use this as a dimension or use it for sorting purposes..
I would call Year as Sorting option instead Week number this case
thanks , will try it now and update you
Hi,
But for the generic question - Can you sort a dimension by another? I ask this because in my case, I'd like to show only the week number (51, 52,01, 02..) and not the year-week; this is just for aesthetics. Is there a way to accomplish this? Show week numbers but sort the week number of year week? It works perfectly when you sort a dimension on measure (like sales etc.) but somehow it doesn't work when the expression is a dimension
Thanks,
Aditya