sort in minichart

[Anonymous]

Hi,

I've made a minichart where months is the dimension. If i look at the values in the list box they are represented correct. Hence;

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

But in my minichart the first value is from April. What am i doing wrong?

Thanks in advance,

//A.

[Anonymous]

Did you create a calendar?

If you do you can add the following line to it:

ORDER BY Datefield asc;

Where Datefield is the field you use to autogenerate your calander from.

[derekjones]

Hi borgannika

Tip on Month Year (or any dating). If you use the format of YYYYMMDD (or YYYYMM in your case) you will always have a sortable date field.

[Anonymous]

Thank you! Don't know why i'm so stubborn with the MonthYear field. YearMonth is better in so many ways 😃

thanks!