Force a chart to show null data

Ignition
1

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>
2

Would null then be considered zero in this instance?

3

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…

4

Can you coerce the nulls to zero in your query?