Rolling 12 months line graph month sort

[vardhancse]

Hi,

Have one trend chart showing rolling 12 months, since it is a rolling 12 months given sort order for months as load order.

Now I need to change the order of months, can please let me know any alternative.

Added one new table like

monthname, monthsort

Jan, 1

Feb, 2

but the issue is that its not taking the given sort order. is there any way to change the order of months while loading.?

[sunny_talwar · Accepted solution]

Two questions:

1) monthname links to the month field in your fact/mastercalendar table?

2) Is this script before you load your fact/mastercalendar? If it is not, then move it ahead of those tables so that the load order is determined through your inline load.

[vardhancse]

Thank you Sunny