Sort computed x axis

[marco_puccetti]

Hello, i need to know how to sort an x dimension of a graph in order to have the dates ordered.

The computed dimension is: =[Month] & '/' & [Year]

that in the graph is showed like the figure attached.

How can i do to get this field ordered by month and year?

Thanks

Marco

[arulsettu]

post your sample app

[crusader_ · Accepted solution]

Hello, Marco

When you create MonthYear field use dual function, smth like below:

=dual([Month]&'/'&[Year],[Year]*100+[Month])

And sort as number Ascending.

Hope this helps.

Regards,

Andrei

[Anonymous]

Hi Marco,

You can go to the sort tab. Uncheck all the checkboxes. Check the expression box and enter you expression into it. Please see screenshot:

[Peter_Cammaert]

Switch places for Month and Year in your calculated  dimension.

[marco_puccetti]

With dual it works.

Thanks

Marco

[#7]

You can also write the expression on the chart or use Max(Date) if you have date field.