Categorical values, such as in a custom field with a pre-defined choice list, are by default sorted alphabetically in reports. However, in many instances there's a preferred or implicit ordering of categorical values. For example, the sequence "cold, cool, hot, ice cold, red-hot, warm" is less natural than "ice cold, cold, cool, warm, hot, red-hot".
Currently, the only solution for enforcing a desired/logical sequence in a report is to add a number in from of each value (i.e. 1-ice cold, 2-cold, 3-cool, etc.) which is cumbersome and restrictive.
Preferred behavior: have the option to have reports recognize the sort sequence in which the pre-defined values in a custom field have been sorted.
|Release time frame|