Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Is there any one that have a good solution on how to arrange labels i charts?
I´m using a field YearMonth (201204) and I would like to show formats like "Mar-12" or "J F M A J......" In the charts I´m using moving annual total (rolling 12month). Is there any functions that could solve this?
I´ve the same issue with field Day (2012-04-30) where I would like to show like rolling 30 days "26 27 28 29 30 31 1 2 3 4 5...."
A issue is also to sort this formats in the right order.
Thanks in advance.
Look at the date and time functions in the F1 help. Use one of these as your dimension(s) maybe?
For good representation in my dimension labels, I create a field MonthYear in my scripts like this:
Date(Monthstart(TempDate),'MMM-YY') as MonthYear,
And for a one character month, something like this:
Dual(LEFT(Month(TempDate), 1), Month(date)) as Month_abbreviation,
I hope that helps you