416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Handling gaps in Line and Area Charts

Hide navigation
RSS
Modified on Mon, 27 Jan 2014 02:57 PM Categorized as Chart, Dimensions, Level-Beginner, Level-Intermediate

Overview

Whenever there are gaps in the dimension, a Line Chart (or Area Chart) will connect the datapoints before and right after the gap. This is the default behavior in Dundas Dashboard.

For example, as seen from the Virtual Table preview below, the source data have gaps in the dimension. These gaps are on the following dates: 18/01/2013, 21/01/2013, 22/01/2013, 24/01/2013 and 25/01/2013.
Preview of Virtual Table showing the gaps in the dimension.

Preview of Virtual Table showing the gaps in the dimension.


The resulting Line Chart will look like this. The chart's data point markers are enabled in this case to clearly indicate the given and missing datapoints.

The resulting Line Chart will look like this. The chart's data point markers are enabled in this case to clearly indicate the given and missing datapoints.


Area Charts demonstrate the same behavior.

Area Charts demonstrate the same behavior.


In contrast, a Bar Chart using the same data source will show the gaps in the dimension by default.

In contrast, a Bar Chart using the same data source will show the gaps in the dimension by default.




Option 1 - Remove Gaps

There is an X-Axis scale property called Remove gaps, wherein the default value is False. If you set this to True, the gaps in the dimension will be removed.

 Remove Gaps property.

Remove Gaps property.


Which will result in the following Charts:

Line Chart with Remove Gaps property set to True.

Line Chart with Remove Gaps property set to True.


Area Chart with Remove Gaps property set to True.

Area Chart with Remove Gaps property set to True.


Bar Chart with Remove Gaps property set to True.

Bar Chart with Remove Gaps property set to True.


Option 2 - Fill gaps with null values

In this workaround, data manipulation is required on your source data. Here, you need to provide the missing dates, and set a NULL value (not zero). For example, here is the Virtual Table preview:

Virtual Table Preview.

Virtual Table Preview.


Which will result in the following Charts:

Line Chart with NULL DataPoint values.

Line Chart with NULL DataPoint values.


Area Chart with NULL DataPoint values.

Area Chart with NULL DataPoint values.


Bar Chart with NULL DataPoint values.

Bar Chart with NULL DataPoint values.


Option 3 - Hide Gaps

With this workaround, you can assign zero values to the empty dimensions, and set the Empty Point Style. Below are the detailed steps:
  1. Create a Time Dimension.
  2. Replace instant date dimension with Time Dimension.
  3. Use 0 (zero) as empty data point value.
  4. On the chart's Empty point Style, use Transparent for the Fill.
     Empty Point Style property.

    Empty Point Style property.



Which will result in the following Charts:

Line Chart showing the gaps in the dimension.

Line Chart showing the gaps in the dimension.


Area Chart showing the gaps in the dimension.

Area Chart showing the gaps in the dimension.


Related Topics


Click to return to: Documentation

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.