Spotfire Ideas Portal
Say you have a month name or some period indicator like 'MAR-16' as a column. Then in the dataset there would be maybe another column with a time stamp. I would like to be able to sort the period indicator column by the values in the time stamp column. So that 'JAN-16' would be bofore 'FEB-16' etc. Currently if you want to acomplish that you need to manually sort. So when you get new data in the data set that you haven't sorted manually yet, the sort order is broken.
I just wanted to add that this would be extremely helpful. There's a related question on the Community site (https://community.tibco.com/questions/sort-order-column-another-column-same-table).
Also someone may want to update the title of this idea to "Sort" instead of "Sor"
Another scenario I usually run into is having a column with categorical value (for example metric name) and i want to use it in dropdown or listbox for selection. The order of items in listbox is column default which is not always alphabetical and I don't want to reorder manually every time there is new value. Ideally, I would like to be able to sort one column based on another one (for example metric_order) where i can identify the order in advance.