Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart where I would like to set the sort to:
OCT-16
NOV-16
DEC-16
JAN-17
etc
Is it possible to pre-set a sort like this?
Thanks,
Daniel
So are you hoping to always get the current Month as the first Month of the sort or is this always Oct based on your fiscal Year? If it is always Oct, you can try this:
Match(Month(Only({1}MonthYearField)), 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9)
you can do that in the script by loading the field as dual, the first value will be the date and the second value will be the sort order Year and MonthOrder (201512,201601,201602), and then in the chart you will sort based on numerical value asc.
Try this:
= | date(Field_Date,'MMM-YY') |
or
The result will be