This article describes how to go from a standard table...
...to a table or visualization where columns with a sample size under a specified threshold (e.g., 50) are made blank:
Requirements
- A table or visualization with rows and columns.
Note: You must apply the rule directly to the input table if you see a table icon in the Data > Data Source > Data field in the object inspector of a visualization.
You will also see a warning in the Rules section of the object inspector if you have applied a rule directly to a non-compatible visualization, and you will need to apply it to the input table instead. For example:
Method
- Select your table or visualization.
- Go to Data > Rules on the object inspector.
- Select Plus (+) > Cell Content > Blank Cells with Small Sample Sizes.
- Select the appropriate threshold under Minimum Column Sample Size.
- By default Also set values of first table statistic to NaN is ticked to set blank cells to NaN.
- Press OK.
Note, this rule uses the Column Sample Size for blanking the cells. A footer (caption) note is also added, which specifies this condition.