Question

In regards to tableau what is nested sorting useful for?

• sorting on a single field appearing in the last column
• sorting alphabetically on a field with long text
• sorting data using values in more than one field
• sorting both alphabetically and numerically on the same field

Answer 1

In regards to tableau nested sorting is useful for sorting data using values in more than one field

Hence, option c - sorting data using values in more than one field is the correct option.

Explanation: Nested sorting is useful when the data or the values to be sorted occurs in more than one category/field/pane. In simple words, nested sorting simply sorts data in sub-fields belonging to different fields.

Note: For the sake of simplicity, let me tell you that 'fields' here simply refers to different panes or columns.

As an example, let us assume that we have a databse of car sales in a particular month of a year that contains a sub-field/sub-category named "Sales" in different fields like "Sedan", "SUV" etc. So as we can see that the sub-field "Sale" has values that occur in every field for car type like Sedan, SUV etc. Hence, nested sorting would be useful here if we want to sort the values of "Sales" month-wise for different categories of cars such as Sedan, SUV, etc. However, sorting can be in ascending or descending order like from the month having the least sales to the month having the highest sales or vice-versa.

Other options are hence incorrect, as they can just be achieved with the help of simple sorting also because these options involve working with single fields and not more than one field.

Thanks!