Forum Discussion
stfox
Helper I
Helper ICustom filter a text column
Hi Folks I have created a frequency distribution (see below). The bins are text columns. Is there are way to custom sort the bins, so that they are in a logical order (0 as first bin, 1-10 next, 11...
stfox Probably easieast/fastest thing will be to change your formula for the custom bins by adding another 0
000
001-010,
011-020,
etc...
Other than that you would need to create another Index Column(number) and then sort Day Elapsed (Binned) by that column.
Like we do with Month names (so they sort 1-12) and not A-Z
Sean
Community Champion
Community Championstfox Probably easieast/fastest thing will be to change your formula for the custom bins by adding another 0
000
001-010,
011-020,
etc...
Other than that you would need to create another Index Column(number) and then sort Day Elapsed (Binned) by that column.
Like we do with Month names (so they sort 1-12) and not A-Z
