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.

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.

Last updated