Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
Data Wrangling
Visualization
Types
Features
Trend Line
Reference Line
Repeat By
Window Calculation
Date/Time Aggregation
Show Range
Highlight
Change Marker
Multiple Y-Axis Columns
Layout Configuration
Column Configuration
Column Configuration Dialog
Color Setting
Color Setting (日本語)
Pin
Save as PNG/SVG
Save as Exploratory Data File
Share/Schedule
URL Link
Category (Binning)
Highlight
Limit Values
Edit Display Name
Missing Value Handling
Rename Column Names
Axis Setting
Axis Formatting
Fit to Screen (Table)
Number of Unique Values Check
Number of Unique Values Check (日本語)
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Missing Value Handling
Missing Value Handling is available in the following charts.
  • Bar
  • Line
  • Area
  • Pie / Ring
  • Histogram
  • Density Plot
  • Boxplot
  • Violin Plot
  • Error bar
  • Error Bar (Summarized Data)
  • Map - Long/Lat
  • Pivot Table
  • Summarize Table

Show Unused Factor Levels

You can set to show or hide the unused factor levels.

Missing Value Hanling

Type

You can set how to fill the missing value at the "Missing Value Handling" option. This option is available in the following chart types.
  • Bar - Y-Axis
  • Line - Y-Axis
  • Area - Y-Axis
  • Scatter (With Aggregation) - Y-Axis
  • Pivot Table - Value
  • Summarize Table - Value
The following options are available.
  • None
  • Fill with NA
  • Fill with Zero
  • Fill with Previous Value First, then Next Value (Only available in Pivot Table and Summarize Table)
  • Fill with Previous Value
  • Fill with Next Value
  • Fill with Next Value First, then Previous Value (Only available in Pivot Table and Summarize Table)
Here are examples of how each option works. Suppose you have Sales data but it misses the data for year 2013 except USCA.

None

No filling happens. If you use a Line chart, It just connects the values. This is the default behavior.

Fill with NA

It fills missing values with NAs. If you use a Line chart, lines will be intermittent.

Fill with Zero

It fills missing values with zeros.

Fill with Previous Value

It fills missing values with the previous values.

Fill with Next Value

It fills missing values with the next values.

Direction

You can select the direction how you fill the missing values. The following options are available. This option is available only in Pivot Table and Summarize Table.
  • All (Down then Across)
    ​
  • Row (Across)
    ​
  • Column (Down)
    ​
  • Column (Down within Group)
    ​
  • Column (Down then Across within Group)
    ​

Range to Fill Through

For the "Fill with Previous Value" and "Fill with Next Value" options, you have the "Range to Fill Through" option. The following options are available.
  • End of Each Group - Value filling happens within each group (Color and Repeat By) range.
  • End of All - Value filling happens for the whole data range.
Previous
Edit Display Name
Next
Rename Column Names
Last modified 5mo ago
Copy link
Contents
Show Unused Factor Levels
Missing Value Hanling
Type
Direction
Range to Fill Through