# SQL date to chart

**URL:** <https://discourse.nodered.org/t/sql-date-to-chart/36787>\
**Category:** General\
**Created:** [1 December 2020 08:01 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787 "2020-12-01T08:01:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![MA.ING](https://avatars.discourse-cdn.com/v4/letter/m/d9b06d/32.png) [@MA.ING](https://discourse.nodered.org/u/MA.ING)\
**Post date:** [1 December 2020 08:01 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787/1 "2020-12-01T08:01:53Z")

</div>

Hi, im trying to get a chart with 7 lines comming from 7 variables from SQL, if i get only 1 variable all is fine in the chart, but if i want 2 or more variables/lines in my chart its imposible to get, someone knows how to do?

I did it in Change node:

[{  
"series": ["DepAvg"],  
"labels": [""],  
"data": [[payload.{  
"x": ."Fecha", "y": ."ExtAvg"  
}]]  
}]

Thanks

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 December 2020 09:01 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787/2 "2020-12-01T09:01:12Z")

</div>

Feed the output into a change node and compare what you see with the requirements from the docs.

---

<div class="post-metadata">

**Author:** ![MA.ING](https://avatars.discourse-cdn.com/v4/letter/m/d9b06d/32.png) [@MA.ING](https://discourse.nodered.org/u/MA.ING)\
**Post date:** [1 December 2020 10:36 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787/3 "2020-12-01T10:36:11Z")

</div>

sorry Colin, but i dont understand what you want to say

my problem is how can i put more lines "y" in my chart from my SQL data

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [1 December 2020 10:40 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787/4 "2020-12-01T10:40:13Z")

</div>

@MA.ING you could use [this solution](https://discourse.nodered.org/t/dynamic-series-identification-from-message-send-data-to-chart/36682/5) as a starting point.

---

<div class="post-metadata">

**Author:** ![MA.ING](https://avatars.discourse-cdn.com/v4/letter/m/d9b06d/32.png) [@MA.ING](https://discourse.nodered.org/u/MA.ING)\
**Post date:** [1 December 2020 10:51 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787/5 "2020-12-01T10:51:36Z")

</div>

Thank you so much Steve, this is exactly what i need, working perfect now

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [15 December 2020 10:51 UTC](https://discourse.nodered.org/t/sql-date-to-chart/36787/6 "2020-12-15T10:51:41Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.