I want to sort the dimension in ascending order.
The values of dimension are (varchar type) : 0,1,2,3~19,20+
I've try to write expression to sort these values.But it didn't work.
Anyone can help?
IF(yourfield < 3, yourfield, IF(yourfield = '3~19', 3, 4))
Put the calculation in sort by Expression under the Sort-tab
Hope attached file helps you.
Select Chart Properties -> Sort -> Select Sort by -> Text and uncheck others.
The 3~19 ia an interval, so the result shoud be:
Numerical sorting doesn't work here, need to be an expression.
Do the following
Select Chart Properties -> Sort -> Select Sort by -> Expression
=Match(DimensionName, '0', '1', '2', '3~19', '20+')
Hope this helps you.
Or just do as i wrote in the first response: IF(yourfield < 3, yourfield, IF(yourfield = ',3~19', 3, 4))
no it's not working.
The result is 0 ,20+, 1 ,2, 3~19
An match methos is ok.
And Inspired by you ,my solution is if(Logins = '20+',4,if(Logins = '3~19',3,Logins))
Thank you all!
Retrieving data ...