As a new user of Dataiku DSS, familiar with MS Excel, I'd like to more easily find the ability to sort a dataset by multiple columns at the same time. This would increase my ability to successfully conduct data analysis and data cleanup.
Only after 4 years of use have I discovered that this can be done from the display menu, by choosing "select sort columnS". and bringing up a dialog box to select multiple columns to sort by.
This feature did not jump out at me. It is really just the "s" in columns that helped me realize that I could sort by multiple columns at the same time. Sorting by multiple columns in DSS is something that I've wanted to do for a long time and had not figured out how to do.
When someone has already got a sort setup on a dataset column. In all other columns there is an additional feature in the column drop-down menu that says something like "Add Sort" or "Additional Sort". This adds this column as the next sort column like one could do in the display menu. It would be nice if that menu did not show up, that the new sort column was added at the top or the bottom of the column sort list. Showing a place where add sort could be added when one already has a sort column set.
If you go back to the column header with a sort already set. You would still get the remove sort option.