How to arrange labels

[#1]

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.   

[Jason_Michaelides]

Look at the date and time functions in the F1 help.  Use one of these as your dimension(s) maybe?

[Anonymous]

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