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?
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
Thank you Max! That worked.