# Reporting nested charts not showing data properly

**URL:** <https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [October 28, 2020, 9:15pm UTC](https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118 "2020-10-28T21:15:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tturner](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tturner/32/19058_2.png) [@tturner](https://forum.inductiveautomation.com/u/tturner)\
**Post date:** [October 28, 2020, 9:15pm UTC](https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118/1 "2020-10-28T21:15:19Z")

</div>

Versions:  
- Ignition - v8.0.16  
- Reporting Module - v5.0.16  
- \*\* Data is scrubbed, used Simulator for example  
- This example only has 1 Pump shown for clarity  
- Indirection is used for that 1 Pump

I have been able to achieve this with indirection in Vision and Perspective.

I am having an issue when using nested Query Data and charting in the reporting module

- A new chart is generated from each row of the nested query, instead of using it as a dataset
- I have tried many variations of Keys for the chart(“History”, “current”, “History.current”, etc) with similar results
- I have also tried putting the chart into the Header/Summary area.  
- I only get one chart, but no data shows up

Surely, there must be something that I am missing:

I have included:  
- Picture of Nested Query  
- Picture of Table Group  
- Picture of Report Designer  
- Picture of Report Preview  
- Example of the Output from the Nested Query

Nested Query

 ![Report Data](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/06202f6aa9ade1aa84d4cb5e02616329db569d16.jpeg)

Table Group

 ![Table Groups](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/8/58ddcef2e0d352620041f5a5123f4bddc5049a0e.jpeg)

Report Designer

 ![Chart Configuration](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/a/dadd577edeef21d3dd20016821f5006459040a52.jpeg)

Report Preview

 ![Report Preview](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/7/374c3e14400f8c73cd0f29229595aaf535e6a2d6.jpeg)

Is this data structure correct for the Nested Table to work? (I am using “current” as the Data Key)

```auto
	<Pumps>
		<row-0>
			<Pump>1</Pump>
			<History>
				<row-0>
					<t_stamp>2020-10-28 11:05:56.428</t_stamp>
					<current>-96.09314991421937</current>
				</row-0>
				<row-1>
					<t_stamp>2020-10-28 11:07:08.428</t_stamp>
					<current>-96.12323655699089</current>
				</row-1>
				<row-2>
					<t_stamp>2020-10-28 11:08:20.428</t_stamp>
					<current>-96.15332319976241</current>
				</row-2>
				<row-3>
					<t_stamp>2020-10-28 11:09:32.428</t_stamp>
					<current>-96.18340984253393</current>
				</row-3>
				<row-4>
					<t_stamp>2020-10-28 11:10:44.428</t_stamp>
					<current>-96.20276641845703</current>
				</row-4>

```

Any help would be appreciated!

---

<div class="post-metadata">

**Author:** ![tturner](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tturner/32/19058_2.png) [@tturner](https://forum.inductiveautomation.com/u/tturner)\
**Post date:** [February 15, 2021, 8:37pm UTC](https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118/2 "2021-02-15T20:37:22Z")

</div>

CLOSED!

Working 1 page per asset with working history trend

Issues corrected by:

- **NOT** using table groups for history data, only associated text tables(Alarms, Etc)
- Using the Nested SQL as shown (more user friendly than python)
- Stayed with “History” as the data Key, “t\_stamp” as the Domain Key

```auto
	<Pumps>
		<row-0>
			<Pump>1</Pump>
			<History>
				<row-0>
					<t_stamp>2021-02-15 07:29:07.204</t_stamp>
					<current>15.1354684631354</current>
				</row-0>
				<row-1>
					<t_stamp>2021-02-15 07:29:08.603</t_stamp>
					<current>15.245782129837</current>
				</row-1>

```

Hop this helps someone else !!!

---

<div class="post-metadata">

**Author:** ![dwoo](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\
**Post date:** [July 29, 2021, 6:35pm UTC](https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118/3 "2021-07-29T18:35:10Z")

</div>

I would like to re-open this issue…seeing it in 8.1.1.  
I’ve tried it in the parent and child tables…no data. Works when NOT in a Table Group…

---

<div class="post-metadata">

**Author:** ![mokam](https://avatars.discourse-cdn.com/v4/letter/m/34f0e0/32.png) [@mokam](https://forum.inductiveautomation.com/u/mokam)\
**Post date:** [January 11, 2022, 6:40am UTC](https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118/4 "2022-01-11T06:40:05Z")

</div>

Hi, did you find something

---

<div class="post-metadata">

**Author:** ![dwoo](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\
**Post date:** [January 11, 2022, 1:24pm UTC](https://forum.inductiveautomation.com/t/reporting-nested-charts-not-showing-data-properly/40118/5 "2022-01-11T13:24:28Z")

</div>

Issue corrected. I was not passing the right parameters to the Chart.