How to Sort Data

This article describes how to take a table with a default sort order:

And sort it by a specific column or row:

Requirements

A Displayr document containing a table that you want to sort.

Please note this requires the Data Stories module or a Displayr license.

Method

Select the table that you want to sort.
Right-click on the column or row header that you want to sort by.
Select Sort and then select one of the following options:
- Ascending (e.g. 1,2,3)
- Descending (e.g. 3,2,1)
- Categories Shown in Columns > By Labels > Ascending (e.g. A,B,C)
- Categories Shown in Columns > By Labels > Descending (e.g. C,B,A)
- Categories Shown in Columns > By Pattern - Sorting by patterns is used to highlight significant patterns in the data. This is sometimes called "diagonalization".
- Categories Shown in Rows > By This Column's Values > Ascending > Select Statistic (e.g. 1,2,3)
- Categories Shown in Rows > By This Column's Values > Descending > Select Statistic (e.g. 3,2,1)

Note: If sorting by values, normally, you'll want to select the top statistic (e.g. %), because it is what will be displayed on the table by default. However, you can also sort by another statistic that is not currently shown on the table.

How to Sort a Table by Values

How to Sort Labels in an Ascending or Descending Order

How to Automatically Sort Table Rows

How to Sort Columns for Entered or Pasted Tables

How to Sort Rows for Entered or Pasted Tables

How to Automatically Sort Tables to Show Patterns in the Data

How to Sort Table Categories Within Each NET

Summary Tables and Crosstabs