Sort order for integer bins

Question & Answer
,
1

Hi all,
I have created bins to represent range of days in a text form. I want to sort them as integers. Is it possible to do it?
image

2

Will they always be those ranges?

In that case you can make an ifelse statement to group them into numbers and sort on that field.

ifelse({range}='0-30',1,{range}='30-60',2,{range}='60-90',3,{range}='90-365',4,5)

Then sort on that ^

2 Likes
3

Thank you Max! That worked.