# Ignition Reporting Dynamic Charts

**URL:** <https://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324>\
**Category:** Ignition\
**Created:** [February 17, 2020, 1:13am UTC](https://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324 "2020-02-17T01:13:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew.Zebic](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Andrew.Zebic](https://forum.inductiveautomation.com/u/Andrew.Zebic)\
**Post date:** [February 17, 2020, 1:13am UTC](https://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324/1 "2020-02-17T01:13:30Z")

</div>

Hi,  
I have a project with multiple sites configured, with potential for more. I would like to show two charts per site configured, in the reporting module. I know there are table groups, which does something similar to what I want, however I would like to be showing charts instead of tables. How would I go about doing this?  
Thanks,  
Andrew

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 17, 2020, 11:53am UTC](https://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324/2 "2020-02-17T11:53:57Z")

</div>

Yes, you want table groups. Start with a data query that yields one row per site. That will be the outer data key. Add a nested query for each chart type that always yields one row (per site). These nested queries will be the data keys for the inner tables, each with just one row. Include any ancillary data about that chart at this level. Add a third level of queries, yielding the chart data per chart type per site.

In the nested tables of the table group, use an unstructured row to hold the desired chart, using the middle level of the queries to supply its properties, and the innermost data key to supply its content.

---

<div class="post-metadata">

**Author:** ![Andrew.Zebic](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Andrew.Zebic](https://forum.inductiveautomation.com/u/Andrew.Zebic)\
**Post date:** [February 18, 2020, 4:36am UTC](https://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324/3 "2020-02-18T04:36:49Z")

</div>

@pturmel Thanks, this worked

---

<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, 1:40pm UTC](https://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324/4 "2021-07-29T13:40:25Z")

</div>

I have a similar issue, but I want a chart associated with the outer data key, and the chart’s only pen (range and pen names) has to ref one of the data item return from the outer data key query in it’s names (like passing a parameter)…can that be done? I see the chart has scripting available but I’m a newbie for swing scripting…  
Also I have a table using the sub-query…