Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
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?
Try creating it like this
Dual(" Year &'-'&replace(upper(Week),'W',''), Year*100 + replace(upper(Week),'W','')) as YearWeek "
This solved my problem
Thank You