# Report Viewer Plotting

**URL:** <https://forum.inductiveautomation.com/t/report-viewer-plotting/6651>\
**Category:** Ignition\
**Created:** [June 5, 2013, 7:43pm UTC](https://forum.inductiveautomation.com/t/report-viewer-plotting/6651 "2013-06-05T19:43:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![WillMT10](https://avatars.discourse-cdn.com/v4/letter/w/7feea3/32.png) [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\
**Post date:** [June 5, 2013, 7:43pm UTC](https://forum.inductiveautomation.com/t/report-viewer-plotting/6651/1 "2013-06-05T19:43:47Z")

</div>

Is there any way to prevent the line graph component, on the report viewer, from plotting Nulls as 0’s? I have a set of data with a new data point for each day that I am plotting. On top of this I am plotting the 2 week moving average for the data. This moving average data has Nulls for the first 13 days and currently the line graph is plotting these as 0’s which misrepresents the data. Any help would be appreciated.

Thanks,  
-Will

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [July 12, 2013, 11:14pm UTC](https://forum.inductiveautomation.com/t/report-viewer-plotting/6651/2 "2013-07-12T23:14:11Z")

</div>

On the dataset that is fueling your report, you could add to your where clause so it throws out 0s and nulls.