This content has been marked as final. Show 2 replies
I have a report where data is presented in a graph.
The time dimention in the graph shows Year-Week, e,g "2017-35".
This dimention is created in the loading script as " Year &'-'&replace(upper(Week),'W','') as YearWeek "
The problem is that the sorting of 'YearWeek' is not correct as you see in the graph below.
How can this be solved?