Sort Year-Week in graph

[stekol61]

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?

[sunny_talwar]

Try creating it like this

Dual(" Year &'-'&replace(upper(Week),'W',''), Year*100 + replace(upper(Week),'W','')) as YearWeek "

[stekol61]

This solved my problem

Thank You