if someone has range categories, such as "0-1", "1-5", "5-10", "10-15"
"10-15" will appear before "5-10" on an axis
but since they're numeric ranges, 10-15 should appear after 5-10
Hi Brad, this should work correctly if you use Charts to bin the data. I'm guessing you have pre-binned the data yourself? There isn't an easy way to sort numbers that have already been combined into strings. Is it an option to store the lower range bound separately as a number in your collection?
@Tom Hollander: thanks, i understand about binning numerical data, but that's not what this is. the data is from a survey, so the original categories are strings of that format.
Fwiw, i think a more nuanced sorting algorithm for strings is needed. For example, if someone has data with categories like "group 1", "group 2", etc all the way up to 10, "group 10" would come before "group 2", and that isn't really proper sorting, because it treats groups of digits as though they were made of individual letters
I think Finder or windows or both do it this way when sorting filenames alphabetically, so it shouldn't be unheard of
I suppose i could have parsed out the numbers from range strings, but i just decided instead to just prepend with a), b), c) etc...