Forum Discussion
Help with displaying week numbers correctly
g4joe yes it will but there is no other way, you cannot have following sort order on number, assumg two column year and week number, if you don't year, you cannot have week no. 1 for 2011 come after week no. 4 of 2010 so you have to have some other value to sort it correctly
2010 1
2010 2
2010 3
2010 4
2011 1
2011 2
2011 3
Hi g4joe ,
This seems to be by design. So workaround is that as parry2k mentioned, use year as legend, and use continuous x axis, or use categorical x axis, then create a measure(measure = 12 fixed value) as trend line, add this in Value field.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
g4joe yes it will but there is no other way, you cannot have following sort order on number, assumg two column year and week number, if you don't year, you cannot have week no. 1 for 2011 come after week no. 4 of 2010 so you have to have some other value to sort it correctly
2010 1
2010 2
2010 3
2010 4
2011 1
2011 2
2011 3
Thanks for your help with this.
It's a pity using categorical axes has a couple of downsides regarding the scroll bars and trend lines.