This article describes how to go from a table with all cells being displayed...
...to one where any cell under a specified threshold has been removed or changed.
Requirements
- A table with rows and/or columns
Method
1. Select your table.
2. Copy the name from Properties > GENERAL > Name.
3. Select Calculation > Custom Code.
4. Click onto the page to place the custom calculation.
5. In the object inspector go to Properties > R CODE.
6. Add a line to the code that defines the table as table = table_name
where table_name is copied from step 2.
7. Add a line to the code using the table[condition] = value
format where value can be an actual value or NA to set the value as missing.
8. Add a line with just the defined table name.
Below is the code from this example that blanks out table cells less than 50:
table = table.Q5.Brand.Image
table[table <50] = NA
table
9. OPTIONAL: Select this output and go to Properties > APPEARANCE > Number format to adjust decimal places.
Next
How to Blank or Cap R Table Cells Based on a Different Statistic Using R