# Force a chart to show null data

**URL:** <https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728>\
**Category:** Ignition\
**Created:** [October 15, 2020, 6:57pm UTC](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728 "2020-10-15T18:57:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![leversole](https://avatars.discourse-cdn.com/v4/letter/l/db5fbb/32.png) [@leversole](https://forum.inductiveautomation.com/u/leversole)\
**Post date:** [October 15, 2020, 6:57pm UTC](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728/1 "2020-10-15T18:57:00Z")

</div>

I have tried everything I know to get the nulls out of a summary pivot query, not having any luck, what I want is the chart to show the date (with no data) in the proper sequence with dates that have data.  
Here is an example of the data. I just want the chart to show all five days (in this example).

```
	<row-0>
		<Day>10/02</Day>
		<K>null</K>
		<C>null</C>
		<H>null</H>
		<T>null</T>
		<D>null</D>
		<L>null</L>
		<R>null</R>
		<S>null</S>
	</row-0>
	<row-1>
		<Day>10/03</Day>
		<K>null</K>
		<C>null</C>
		<H>null</H>
		<T>null</T>
		<D>null</D>
		<L>null</L>
		<R>null</R>
		<S>null</S>
	</row-1>
	<row-2>
		<Day>10/04</Day>
		<K>1</K>
		<C>null</C>
		<H>3</H>
		<T>null</T>
		<D>null</D>
		<L>null</L>
		<R>null</R>
		<S>null</S>
	</row-2>
	<row-3>
		<Day>10/05</Day>
		<K>null</K>
		<C>null</C>
		<H>null</H>
		<T>2/T>
		<D>null</D>
		<L>null</L>
		<R>4</R>
		<S>null</S>
	</row-3>
	<row-4>
		<Day>10/06</Day>
		<K>2</K>
		<C>2</C>
		<H>null</H>
		<T>null</T>
		<D>null</D>
		<L>1</L>
		<R>null</R>
		<S>null</S>
	</row-4>
	<row-5>
		<Day>10/07</Day>
		<K>null</K>
		<C>2</C>
		<H>null</H>
		<T>null</T>
		<D>null</D>
		<L>null</L>
		<R>1</R>
		<S>null</S>
	</row-5>
```

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 15, 2020, 7:18pm UTC](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728/2 "2020-10-15T19:18:26Z")

</div>

Would null then be considered zero in this instance?

---

<div class="post-metadata">

**Author:** ![leversole](https://avatars.discourse-cdn.com/v4/letter/l/db5fbb/32.png) [@leversole](https://forum.inductiveautomation.com/u/leversole)\
**Post date:** [October 15, 2020, 7:20pm UTC](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728/3 "2020-10-15T19:20:33Z")

</div>

Yes, I was not clear above, I want a stacked bar chart as the end result, a normal XY or timeseries chart shows dates with no data, trying to get a stacked bar chart to do the same…

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 15, 2020, 8:14pm UTC](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728/4 "2020-10-15T20:14:43Z")

</div>

Can you coerce the nulls to zero in your query?