Static line - set analysis

[#1]

Hi All,

I have a line chart for monthly data from Dec-15,Jan-16,Feb-16,......Sep-16.

When I select any SalesDate value , my graph should not be changed the order from Dec,Jan,Feb,Mar,.....Sep.

Please advise.

Thanks in advance.

[MK_QSL]

Go to Sort Tab

Untick Sort By Expression (Date)

Tick Numeric Value

[#3]

Thank You mrkachhiaimp.

If I do same, Dec going to last value. I want it first value in the sequence.

[trdandamudi]

See if the attached works for you...

[MK_QSL · Accepted solution]

Sort by Expression

Only({1}Match(Month,'Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov'))

[jagan]

Hi,

You can use MonthYear as dimension, if you just display Month alone it will be confusing for users.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Remove the Sort Expression and try.

Regards,

Jagan.