# Omit Zeros in Data Series

**URL:** <https://forum.inductiveautomation.com/t/omit-zeros-in-data-series/33238>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [March 19, 2020, 2:17pm UTC](https://forum.inductiveautomation.com/t/omit-zeros-in-data-series/33238 "2020-03-19T14:17:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dturner](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dturner](https://forum.inductiveautomation.com/u/dturner)\
**Post date:** [March 19, 2020, 2:17pm UTC](https://forum.inductiveautomation.com/t/omit-zeros-in-data-series/33238/1 "2020-03-19T14:17:16Z")

</div>

I am using a Timeseries chart to trend the data below. I am looking to omit the zeros when trending. Is there an option in the Timeseries setup that allows for a user to exclude values?

 ![Series%20Data](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/07ed8c436dda800e85e30033940a87523a3f9915.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 19, 2020, 2:26pm UTC](https://forum.inductiveautomation.com/t/omit-zeros-in-data-series/33238/2 "2020-03-19T14:26:30Z")

</div>

Don’t try to do it from the chart (since that wouldn’t be an option I would expect the chart to have) - do it with your query. Look into the UNION statement; roughly, it looks like you could:

```sql
SELECT Series, First Shift as Data from {table}
WHERE Data > 0
UNION ALL
Select Series, Third Shift as Data from {table}
WHERE Data > 0

```

That should output a single result dataset, with only two columns. You’ll likely need to order them so the timestamps are in the correct sequence, which may require a subquery, but I think looking to solve this in the chart is the wrong place.

---

<div class="post-metadata">

**Author:** ![dturner](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dturner](https://forum.inductiveautomation.com/u/dturner)\
**Post date:** [March 19, 2020, 2:33pm UTC](https://forum.inductiveautomation.com/t/omit-zeros-in-data-series/33238/3 "2020-03-19T14:33:35Z")

</div>

Thank you for the quick response! We are trying to trend both First and Third shift on the same chart. I will go back to our SQL team and discuss other options.