Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
How do I manually sort the month selection tab to show the order of months the right way. Please view the image below for further clarification:
Please advise. Thanks in advance.
Best Regards,
R
If you want to sort the months manually then use match function like
=Match(Yourmonthfield,'December','February','January','May')
and type this code in the Expression tab.
use sort sequence for that like
Load * inline
[
Month, SeqOrder
December, 1
February, 2
January, 3
May, 4
];
and in list box month uncheck all and then select expression and type SeqOrder there
Goto the Sort Tab of the chart or list box. Click on the Expression. Write something like this
Match(<your month field>,'December','February','January','May)
If you want to sort the months manually then use match function like
=Match(Yourmonthfield,'December','February','January','May')
and type this code in the Expression tab.
Go to the sort tab, remove all existing sorting and add this "month(date#(Mon,'MMM'))" where "Mon" is the name of your field.
Thanks,
Jyotsna
Hi Ram,
In load script arrive a new month field like below, and in Sort tab of chart properties -> Number -> Select Ascending/descending based on your requirement.
TableName:
LOAD
*,
Date(DateDimensionName, 'MMMM')
FROM DataSource;
Regards,
Jagan.
Hi Ram,
I think doing this script is better option then using Match() in Sort tab, because wherever you are using Month as dimension there you need to give this. It is difficult to handle if you are using Month in multiple charts/listboxes.
Regards,
Jagan.
Hi,
Use this expression in Sort tab for sorting the month names as you like
=Only({1} Match(Month,'Janaury','Febraury','March','April','May','June','July','August','September','October','November','December'))
Note: Please change the months in the expression as per your requred sort order.
Hope it heps you..