How to change the order?

[#1]

Anyone knows how to change the order of this sequence?

[SergeyMak]

In load script use dual function for month calculation

DUAL(Num(Month(Date)),Month(Date)) AS Month

Then sort by numeric in a chart

[chiru_thota]

You can also define Inline table in you data model.

and use Month_Sort for sorting    chart --> Sort tab ----> Expression --> max({1} Month_Sort)

LOAD * INLINE [

Month,Month_Sort

Jan,1

Feb,2

Mar,3

Apr,4

.......... so on

]

[#4 · Accepted solution]

Try the following expression in the Chart,under Sort tab enable expression for corresponding dimension name

=Wildmatch(Dimensionname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

hope it will work...

[sundarakumar]

If u have a date field and u r showing data by month, then u can show it in order with the data field.

In sort use the expression  num(Date_field) and ascending.. this will work..

If u have data by onth, then u will have to create inline table to sort the month as shown by Chiru and u will have to link the month in the inline with ur data model.

Hope this helps.

Sundar

[#6]

If your calender is normal

then follow Chranjeevi's proposed solution

if your calender is financial calender

Follow like this

LOAD * INLINE [

Month,Month_Sort

Apr,1

May,2

Jun,3

Jul,4

.......... so on

]

and in Sort tab, use this expression : =Only({1} Month_Sort)

[its_anandrjs]

Load a inline table like

LOAD * INLINE [

Month,Month_Sequence

Jan,1

Feb,2

Mar,3

Apr,4

.......... so on

]

and use the Month_Sequence field in the properties -> expression -> type script like for sorting

Or

in properties -> expression -> type script like

=Match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

[CELAMBARASAN]

How did you created the month field from date?

Using Simply Month function will give you month in Dual format, in that case you don't face this kind of issues.

"Month(DateFieldName) AS Month"