# Nulls in trend data

**URL:** <https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685>\
**Category:** Ignition\
**Created:** [January 14, 2013, 8:34pm UTC](https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685 "2013-01-14T20:34:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [January 14, 2013, 8:34pm UTC](https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685/1 "2013-01-14T20:34:53Z")

</div>

Im having the same problem as the other post on a version 7.5.2 (b1146) install.

I am going to upgrade to the latest but was wondering about deleting anything with a 600 dataintegrity code out of the history tables. can I just delete everything out of the table or should I limit it on something else?

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [January 14, 2013, 8:57pm UTC](https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685/2 "2013-01-14T20:57:00Z")

</div>

I deleted all the rows with 600 dataintegrity and the tag id that I was having a problem with, but I wouldn’t think deleting all of the 600 dataintegrity rows would hurt… They shouldn’t really be doing anything anyway.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 14, 2013, 9:41pm UTC](https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685/3 "2013-01-14T21:41:32Z")

</div>

Yeah you can get rid of those records. It won’t hurt anything.

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [January 15, 2013, 12:43am UTC](https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685/4 "2013-01-15T00:43:35Z")

</div>

ok, because I have a ton of them.

On another note, is there any way to make the trend chart flatline the missing data instead of leaving spaces in the chart?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 15, 2013, 1:53am UTC](https://forum.inductiveautomation.com/t/nulls-in-trend-data/5685/5 "2013-01-15T01:53:56Z")

</div>

No, you would have to put valid data in the tables at that time where the value is zero. The gap is showing that there is no data for that time period.