How to Create a Multiway Table

Multiway tables in Displayr are akin to pivot tables in Excel, so they are useful when wanting to see counts or aggregate numeric data across all combinations of categories in multiple variable sets. However, they are R-based and do not include the default stat testing applied to the built-in drag and drop tables. If significance testing is needed, you will need to use the filter one variable set by another automation, see How to Rebase One Question Based on Another Question.

This article describes how to create a table with multiple categorical variables and, optionally, a numeric variable. Similar to a pivot table in Excel.

Requirements

A Displayr document with a data set.

Method

1. From the toolbar, go to Table > Multiway.
2. In the object inspector, go to Data > Rows and select the rows for the table.
3. OPTIONAL: In Data > Columns select the columns for the table.
4. OPTIONAL: Select a numeric variable in the Numeric drop-down.
5. Select the Statistic to show in the table.
6. OPTIONAL: Tick the Hide empty rows and Hide empty columns boxes if you wish to hide where there is no data.