Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have graphic with Month number on X-as.
I sort on Month number, but want to present Month Name.
How can i do this?
Use calculated Dimension instead of Month Number
Dual([Month Number],Subfield('$(MonthNames)',';',[Month Number])
I get error in calculated dimension.
can you upload your qvw?
Use month name as dimension and under the sort tab; select "Expression" and input month number.
Try as dimension
=Month(Makedate(2014,[Month Number]) )
Month function automatically returns the month name as text and (because it's a dual value) keeps the Month Number for sorting numerically.
edit: And it would be even better to create a field in the load script like this to get Month dual values with text and number from your [Month Number] field.
Hi,
best answer so far.
Also possible:
=Month(Date#(monthnum,'MM'))
hope this helps
regards
Marco
Simple,
Use Expression field.
AC
Enclosed
Simple load inline with
No Month
1 Jan
2 Feb
3 Mar
4 Apr
5 May
6 Jun
7 Jul
8 Aug
9 Sep
10 Oct
11 Nov
12 Dec
And sort with Expression sort
Inline[No]