# Chart Report SQL Vision

**URL:** <https://forum.inductiveautomation.com/t/chart-report-sql-vision/79170>\
**Category:** Ignition\
**Tags:** reporting, vision, ignition81\
**Created:** [September 14, 2023, 3:55pm UTC](https://forum.inductiveautomation.com/t/chart-report-sql-vision/79170 "2023-09-14T15:55:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_Gomez](https://avatars.discourse-cdn.com/v4/letter/m/f0a364/32.png) [@Miguel\_Gomez](https://forum.inductiveautomation.com/u/Miguel_Gomez)\
**Post date:** [September 14, 2023, 3:55pm UTC](https://forum.inductiveautomation.com/t/chart-report-sql-vision/79170/1 "2023-09-14T15:55:26Z")

</div>

Hello All,

I need your help with something that is giving me a headache.

I need to graph the data of 3 encoders in the same graph Axis X: Time and Y:Value

Currently I have the data in different SQL tables  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/e/cee1d5ffe7716c31a0057143ac7d05c8b49a28de.png)

In ignition reporting I'm trying with Named Queries  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/1/e1442e93231a748345797794712953b9653c9f84.png)

But it just graph the first set because I just can put one data key

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/4/f4c92ecbe82617ab632ec41e137f73748de47af4.png)

I tried with SQL UNION but it sends me a huge table with a lot of repeated data, I tried with just one table with all the data and one additional column for each Encoder (Encoder1, encoder 2, encoder3)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab069b66492df305afe07366d3a9f08bd69783d2.png)

But the same thing, There is no way to select just the data of the encoder 1 or 2 etc.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/7/970625af7f07b3a623b5daea74d11a2cb5549000.png)

Do you know how can I Graph my data of the 3 encoders in the same graph?

Thank you

---

<div class="post-metadata">

**Author:** ![Miguel\_Gomez](https://avatars.discourse-cdn.com/v4/letter/m/f0a364/32.png) [@Miguel\_Gomez](https://forum.inductiveautomation.com/u/Miguel_Gomez)\
**Post date:** [September 18, 2023, 4:35pm UTC](https://forum.inductiveautomation.com/t/chart-report-sql-vision/79170/2 "2023-09-18T16:35:45Z")

</div>

Well it was not possible because the date data in each tables wasn't the same so I did 3 different charts in my report and the customer preferred in this way.