month order on graph

[#1]

Hi,

Please see attached. We need the graph to show results in month order on fiscal year (i.e. April through to March).

As you can see it's not showing in order irrespective of 'sort' option.

Can someone please help?

Chris

[anat]

check below app..

[anat]

do below changes in ur app.

SET MonthNames='Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar';

add below script:

LOAD * INLINE [

    Month, SEQ

    Jan, 10

    Feb, 11

    March, 12

    April, 1

    May, 2

    Jun, 3

    Jul, 4

    Aug, 5

    Sep, 6

    Oct, 7

    Nov, 8

    Dec, 9

];

and in  ur table add sort for Month column by expression (SEQ) ascending and  remove sort for all columns

[Anonymous · Accepted solution]

Hi Chris,

Two things you have to do :

1. In your data the month names are not consistent. you have month name Jan and rest all Month names with full abbreviations. Make sure you correct that to show full month name.

2. Second add this inline table in your script.

LOAD * INLINE [

Month,sortID

April,1

May,2

June,3

July, 4

August,5

September,6

October,7

November,8

December,9

January,10

February,11

March,  12

];

Now reload the app. and then in the sort order of the chart .. check option for expression then given sortid as your expression. Please see attached app.

Please let us know if that helps