UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis Register now >>

Articles in this section

See more

How to Blank Cells with Small Sample Sizes

  • Updated
Follow

This article describes how to go from a standard table...

ShowLowColumnN.png

...to a table or visualization where columns with a sample size under a specified threshold (e.g., 50) are made blank:

BlankSmallColumnN.png

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 Properties 26UI_ObjectInspector.png of a visualization.

TableInput.png

You will also see a warning in the Rules section of Properties 26UI_ObjectInspector.png 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:

RuleCannotBeApplied.png

Method

  1. Select your table or visualization.
  2. Go to Data > Rules on the object inspector 26UI_ObjectInspector.png.
  3. Select Plus (+) > Cell Content > Blank Cells with Small Sample Sizes.
  4. Select the appropriate threshold under Minimum Column Sample Size.
  5. By default Also set values of first table statistic to NaN is ticked to set blank cells to NaN.
  6. 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.

Next

How to Use Rules in Displayr

Related articles