Forum Discussion
Custom 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-20 and so on). As a hack I have added a text prefix (a, b , c to allow sorting), but that is a rubbish solution.
Does anyone have a better idea?
Cheers
Steve
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
2 Replies
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
