How to Change the Missing Data (NaN) Symbol in Tables and Visualizations

You can set what categories and data are included in tables and analyses via the Missing Data settings in the Value Attributes of a Variable Set, see Variable Sets. However, sometimes you do want to show a category on a table that may be missing data for some of the cells in your table. In Displayr, missing values in built-in tables are shown by NaN, but you are able to change the NaN to something else if needed. This article describes how to apply a rule to go from a table showing missing values as NaN...

...to a table or visualization where the NaN has been replaced with specified text (e.g. - ):

Requirements

• A table or visualization.

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 of a visualization.

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

1. Select your table or visualization.
2. Go to Data > Rules > + > Cell Content > Change Missing Data (NaN) Symbol in the object inspector .
3. Enter the text to replace the missing data (NaN).
4. Press OK.

Next

How to Use Rules in Displayr

How to Ignore Missing Data in the Column Sample Sizes of a Table

How to Hide and Remove Categories (Missing Values)