This article describes how to filter data using the built-in row and column manipulation settings in Displayr's Visualizations and Paste/Enter Table outputs. Functionality includes:
Method 1 - Hide empty rows/columns
Method 2 - Hide rows/columns with small sample sizes
Method 3 - Display specific rows and columns
Method 4 - Hide specific rows and columns
Method 5 - Select which Rows and Columns to Show using Controls
Method 6 - Number of rows/columns from top/left to show
Method 7 - Number of rows/columns from bottom/right to show
For example, in this post, I have used the following table:
Requirements
- A Displayr Visualization, excluding Chart with Test Visualizations.
- A table created using the Table > Paste or Enter Table.
- Method 2 only: Column Sample Size, Column n, Sample Size, or Base n statistic.
Note: outputs mentioned above contain different types of filtering possibilities, which can be found in the object inspector under the Inputs > ROW MANIPULATIONS and COLUMN MANIPULATIONS:
Method 1 - Hide empty rows/columns
This option hides rows or columns that don't contain any data.
- Select the visualization or table on your Page.
- To hide empty rows, go to the object inspector > Inputs > ROW MANIPULATION and select Hide empty rows.
To hide empty columns, go to the object inspector > Inputs > COLUMN MANIPULATION and select Hide empty columns.
Method 2 - Hide rows/columns with small sample sizes
This option removes rows or columns with a low sample size as defined in Step 4.
- Ensure that the input source of the visualization or table contains one of the following statistics: Column Sample Size, Column n, Sample Size, or Base n (see requirements).
- Select the visualization or table on your Page.
- To hide rows with small sample sizes, go to the object inspector > Inputs > ROW MANIPULATION and select Hide rows with small sample sizes.
To hide columns with small sample sizes, go to the object inspector > Inputs > COLUMN MANIPULATION and select Hide rows with small sample sizes. - A Sample size cut-off dialog box will appear after completing the above step(s). Input the minimum sample size required for the data to appear (e.g., 30 responses).
Method 3 - Display specific rows and columns
- Select the visualization or table on your Page.
- To display specific rows, go to the object inspector > Inputs > ROW MANIPULATION > Select Rows to show by and select Typing row names or indices.
To display specific columns, go to the object inspector > Inputs > COLUMN MANIPULATION > Select Columns to show by and select Typing row names or indices. - Input either row/column number you wish to show, separated by a comma (e.g., 1,2,3), or input the exact row/column labels you want to show, separated by a comma (e.g., Strongly disagree, Somewhat disagree).
Displayr will return a table showing rows 1, 2, and 3, and columns Strongly disagree and Somewhat disagree. All other rows and columns are hidden.
Method 4 - Hide specific rows and columns
By default, the NET, Total, and SUM rows/columns are hidden from the final output. To change the default settings:
- Select the visualization or table on your Page.
- To hide specific rows, go to the object inspector > Inputs > ROW MANIPULATION > Rows to ignore.
To hide specific columns, go to the object inspector > Inputs > ROW MANIPULATION > Columns to ignore. -
Specify the rows/columns you wish to ignore by adding them to the list, referencing the name of the row/column, again separating each item by a comma.
Method 5 - Select which Rows and Columns to Show using Controls
See: How to Select Which Rows or Columns to Show in a Visualization Based on a Control Box Selection
Method 6 - Number of rows/columns from top/left to show
- Select the visualization or table on your Page.
- To specify the number of rows to show from the top, go to the object inspector > Inputs > Number of rows from the top to show.
To specify the number of columns to show from the left, go to the object inspector > Inputs > Number of columns from the left to show. - Input the desired number of rows (e.g., 2) and columns to be shown (e.g., 3).
Displayr will return a table showing the first two rows and the first three columns from the left.
Method 7 - Number of rows/columns from bottom/right to show
- Select the visualization or table on your Page.
- To specify the number of rows to show from the bottom, go to the object inspector > Inputs > Number of rows from the bottom to show.
To specify the number of columns to show from the right, go to the object inspector > Inputs > Number of columns from the right to show. - Input the desired number of rows (e.g., 2) and columns to be shown (e.g., 3).
Displayr will return a table showing the last two rows and the three columns from the right.
See Also
How to Select Which Rows or Columns to Show in a Visualization Based on a Control Box Selection
How to Select and Order Rows or Columns to Show in a Visualization Based on a Calculation
Comments
0 comments
Article is closed for comments.