Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check below app..
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
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