# How to chart a nested query in a report

**URL:** <https://forum.inductiveautomation.com/t/how-to-chart-a-nested-query-in-a-report/17107>\
**Category:** Ignition\
**Created:** [February 23, 2018, 2:04pm UTC](https://forum.inductiveautomation.com/t/how-to-chart-a-nested-query-in-a-report/17107 "2018-02-23T14:04:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Claus\_Nielsen](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\
**Post date:** [February 23, 2018, 2:04pm UTC](https://forum.inductiveautomation.com/t/how-to-chart-a-nested-query-in-a-report/17107/1 "2018-02-23T14:04:51Z")

</div>

As the title says, how do I create a chart of a nested query in a report?  
It just says No Data, however when showing the nested query data in a table all the rows are there.

---

<div class="post-metadata">

**Author:** ![Claus\_Nielsen](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\
**Post date:** [February 23, 2018, 2:07pm UTC](https://forum.inductiveautomation.com/t/how-to-chart-a-nested-query-in-a-report/17107/2 "2018-02-23T14:07:47Z")

</div>

Never mind, figured it out. Don’t use the “Chose Data Key” button to set the domain key and the data key for pens as it will set it to incorrect values.

---

<div class="post-metadata">

**Author:** ![Claus\_Nielsen](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\
**Post date:** [February 23, 2018, 2:19pm UTC](https://forum.inductiveautomation.com/t/how-to-chart-a-nested-query-in-a-report/17107/3 "2018-02-23T14:19:21Z")

</div>

Other question though, why is there no “Calculated Values” of nested query columns, e.g. the max or min?

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [July 2, 2020, 9:55pm UTC](https://forum.inductiveautomation.com/t/how-to-chart-a-nested-query-in-a-report/17107/4 "2020-07-02T21:55:10Z")

</div>

Did you set the checkbox above the data sources for “show calculations”?

I tried that on a nested query and it worked. Granted, your question is from over 2 yrs ago so maybe the response will help others.