How to Automatically Sort Tables to Show Patterns in the Data

Displayr makes it easy to tell the story in a data table; you can automatically sort the rows, columns, or both, based on patterns of significance in the data.

This is sometimes called "diagonalization". By making the patterns clearer it helps communicate meaning in the data.

This article describes how to go from an unsorted table:

To a table sorted by a pattern, in this case by row patterns:

Requirements

• A table created in Displayr from a variable or variables in your data set. 

Method 1 - Does not automatically update when data changes

1. Select your table.
2. Right-click on any row (or column) and select Sort > Categories Shown in Rows > By Pattern (or Categories Shown in Columns) > By Pattern.

Method 2 - Automatically updates when data changes

1. Select your table.
2. From the object inspector, go to Data > Rules > + > Sort/Reorder > Order Rows by Pattern or Order Columns by Pattern.
3. (OPTIONAL) Enter row/column labels under Exclude from sort (in addition to NET/SUM).
4. (OPTIONAL)  Enter row/column labels under Never exclude from sort.
5. Click OK.

Next

How to Sort a Table Where the Sort Order Does Not Update with the Data

How to Automatically Sort Rows and Columns