Sometimes you may have rows and/or columns in your table or visualization that show as missing data (NaN), 0%, or 0. This could be due to filtering or because a survey question was only asked of a subset of respondents. In these cases, you may want to tidy your table/visualization and hide these empty rows and/or columns. This article describes how to go from a table or visualization with entire rows and/or columns of 0% or missing data...
..to a table/visualization where these empty rows and columns are removed:
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 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 in the object inspector.
- Click Plus (+) > Rows/Columns > Hide Empty Rows and Columns, Hide Empty Rows, or Hide Empty Columns.
- Click OK.
A note is added to the footer (caption) when any rows or columns have been removed.