Sort the Data Table
As any table you might have dealt with, the Data Table can be sorted by any given column, given that the column has a way to be ordered.
To do this, simply reach out to the column menu and go to Sort. Then choose whether you want ascending or descending order.
This will sort all the rows based on the columns ordering.
For columns that do not present a clear ordering, sorting will be done
alphabetically. This applies to category, and text.
If you have a categorical variable that has a clear ordering but it doesn’t sort properly, check how to convert it to an ordinal variable by specifying the ordering in categorical variables.
Examples of this kind of variables are shirt sizes, where “S” is smaller than “M”, which is smaller than “L”, or survey answers like “Disagree” which is smaller than “Don’t Mind/Don’t Know”, which is smaller than “Agree”.
Was this page helpful?