---
schema_version: "1"
id: 616eaf9d2ad19b4046eaac4b82118370042525c936666b34f6059ece92a4aad9
title: Handle Missing Values in Line Charts
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_chart_cumulative.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_chart_cumulative.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e2c260a60ecd208e73cd789f5f842e2f651cd69b0b4f85817d2f5a0a0af49915
description: Charts can display gaps to highlight missing data. Or charts can ignore the missing data and show a continuous line that connects the data points. For periods of missing data in timeline charts, you can make cumulative lines horizontal to indicate that no change occurs.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Handle Missing Values in Line Charts

Charts can display gaps to highlight missing data. Or charts can ignore the missing data and show a continuous line that connects the data points. For periods of missing data in timeline charts, you can make cumulative lines horizontal to indicate that no change occurs.

To configure how a chart handles missing data, set one of the following options in the Missing Value chart property.

Show as gaps

The graph connects contiguous data points and shows gaps whenever data is missing. In the following example, there’s a separate graph for customer and partner account types.

![The graph shows gaps where there's missing data.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_charts_show_missing_values_as_gaps.png)

Ignore, show continuous line

The graph connects all data points, glossing over missing data. The graph starts at the first data point and ends at the last for each grouping.

![The graph shows a continuous line, connecting each data point.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_charts_show_missing_values_as_continuous.png)

Use prior values

Uses the value prior to the missing data point to indicate no change. Use this option for charts that show cumulative values, such as timeline.

Let’s look at an example. Because no deals closed between February 20 and 23, the cumulative value doesn’t change for the partner line. To show no change, the chart uses the same value from the previous data point on February 19. This chart is more accurate than the previous graph, which is misleading because it shows an upward trend during this same time period.

![The graph shows no changes in cumulative values where there's missing data.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_charts_show_missing_values_as_prior_values.png)

Use prior values (trimmed)

The graph ends at the last data point. For instance, looking at the following example, this graph is the same as the Use Prior Values graph, except that it’s truncated on the right because there’s no data after March 5.

![The graph shows no changes in cumulative values where there's missing data, but doesn't extend the graph passed the last data point.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_charts_show_missing_values_as_prior_values_trimmed.png)