# Designer - reporting - Timeseries - Gaps when data has null

**URL:** <https://forum.inductiveautomation.com/t/designer-reporting-timeseries-gaps-when-data-has-null/14011>\
**Category:** Ignition\
**Created:** [April 11, 2017, 10:38am UTC](https://forum.inductiveautomation.com/t/designer-reporting-timeseries-gaps-when-data-has-null/14011 "2017-04-11T10:38:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilan](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\
**Post date:** [April 11, 2017, 10:39am UTC](https://forum.inductiveautomation.com/t/designer-reporting-timeseries-gaps-when-data-has-null/14011/1 "2017-04-11T10:39:00Z")

</div>

Hello,

I tried to create a timeseries chart in the report designer and found gaps in the time series. I struggled for a while with the gap threashold and trying to find what caused this.

As my database has null values for incomplete datasets I found that the charts then had gaps when trying to create a timeseries. This was resolved by setting the query to exclude null values when returning rows and used the clause: where _columname_ IS NOT NULL

Attached is a screenshot, I thought I would just document this to help anyone else who came across this.

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a359fe621ce0a1e1d85ec242a82895578fc94fec.PNG)

---

<div class="post-metadata">

**Author:** ![Dilan](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\
**Post date:** [April 12, 2017, 6:11am UTC](https://forum.inductiveautomation.com/t/designer-reporting-timeseries-gaps-when-data-has-null/14011/2 "2017-04-12T06:11:53Z")

</div>

Hello all,

So while my solution worked for one set of data where I can skip null, I have a problem with another set where excluding null interferes with the dataset. If anyone has any ideas on how to get the chart to draw lines between null values it would be appreciated if you can share them.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 12, 2017, 10:35am UTC](https://forum.inductiveautomation.com/t/designer-reporting-timeseries-gaps-when-data-has-null/14011/3 "2017-04-12T10:35:01Z")

</div>

If I recall correctly, the underlying JFreeChart objects expects nulls as indicators to deliberately break continuous lines. If so, you won’t find a solution short of completely re-implementing JFreeChart’s renderers. You might just have to create a non-null value from the adjacent rows to replace the null.

---

<div class="post-metadata">

**Author:** ![Dilan](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\
**Post date:** [April 12, 2017, 1:46pm UTC](https://forum.inductiveautomation.com/t/designer-reporting-timeseries-gaps-when-data-has-null/14011/4 "2017-04-12T13:46:59Z")

</div>

Hello Phil,  
Thank you for your response, I do see what you mean about JFreeChart’s renderers.  
I’ll update all on how I get along from here.