order of display x-axis items

[buzzy996]

hi guys,

right now my x-axis objects are displaying like below.

I'm expecting to display 10days+ object at right side end!

any suggestion?

thanks

[Anonymous]

Hello,

go to sort tab in your chart and, in the expression box type Left(0&x-axis_field,2)

[#3]

there are a coup-le of options

Please go to the sort tab and you can chhose how you want to sort - depending on how your dimension is defined may help determine ascending/descending/ a to z, etc.

Another option is to crate an inline of your dimesnions in the order you want and then select the sort of load order

[buzzy996]

hi,it's not working..i'm using calculated expression as dimension.

[buzzy996]

hi,sorting won't work..i've to try inline options.

thanks

[#6]

any chnace you can post your application?

[swuehl]

When creating the dimension values in your calculated dimension,create the values as duals, then sort dimension numeric, something like:

=If( FIELD <= 10,dual( '<=10', 1),

         If(FIELD <= 15, dual(' 10 < x <= 15', 2), dual( ' > 15', 3) )

)

[buzzy996 · Accepted solution]

ya,it's resolved already..thanks.