Articles in this section

How to Filter Rows and Columns in Visualizations and Tables Without Code

  • Updated
Follow

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:

mceclip14.png

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:mceclip0.png

Method 1 - Hide empty rows/columns

This option hides rows or columns that don't contain any data. 

  1. Select the visualization or table on your Page.
  2. 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.

  1. 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).
  2. Select the visualization or table on your Page.
  3. 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.
  4. 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). mceclip1.png

Method 3 - Display specific rows and columns

  1. Select the visualization or table on your Page.
  2. To display specific rows, go to the object inspector > Inputs > ROW MANIPULATION > Select Rows to show by and select Typing row names or indices.
    mceclip1.png
    To display specific columns, go to the object inspector > Inputs > COLUMN MANIPULATION > Select Columns to show by and select Typing row names or indices.
    mceclip3.png
  3. 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. 
mceclip4.png

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:

  1. Select the visualization or table on your Page.
  2. To hide specific rows, go to the object inspector > Inputs > ROW MANIPULATION > Rows to ignore.
    mceclip5.png
    To hide specific columns, go to the object inspector > Inputs > ROW MANIPULATION > Columns to ignore.
    mceclip7.png

  3. 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

  1. Select the visualization or table on your Page.
  2. 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.
    mceclip8.png
    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.
    mceclip9.png
  3. 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. 
mceclip10.png

Method 7 - Number of rows/columns from bottom/right to show

  1. Select the visualization or table on your Page.
  2. 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.
    mceclip12.png
    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.
    mceclip13.png
  3. 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. 

mceclip11.png

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

 

 

Related articles