UPCOMING WEBINAR: DIY Data Cleaning & Prep: Super Fast, Super Good This article describes how to 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.