There are various ways to hide rows or columns based the sample size. For built-in drag and drop tables, see How to Hide Rows and Columns with Small Sample Sizes in a Table. If using R code to create your table, see How to Hide Rows or Columns Based on Sample Size Using R. This article describes how to do this for for specialty tables (i.e. Paste or Enter Table) or visualizations.
For example, you can go from a table showing all rows and columns...
...to a new table or chart where only specific columns or rows are shown based on the sample size.
Requirements
- A visualization created using Table
> Paste or Enter Table or Visualization
from the toolbar. See How to Connect a Table to a Pasted R Table and How to Create a Column Chart from a Table for steps on how to create these.
- A sample size statistic, such as Column Sample Size, Sample Size, Column n, or Base n.
Method
1. Select your visualization.
2. Go to Data > Column Manipulations and tick Hide columns with small sample size.
3. Change the default value for Sample size cut-off as desired.
4. OPTIONAL: Go to Data > Row Manipulations and tick Hide rows with small sample size.
5. OPTIONAL: Change the default value for Sample size cut-off as desired.
6. Adjust the number of decimal places via Appearance > Appearance > Number format as desired.