# MySQL Array or Arrays to line chart

**URL:** <https://discourse.nodered.org/t/mysql-array-or-arrays-to-line-chart/12976>\
**Category:** General\
**Created:** [6 July 2019 15:35 UTC](https://discourse.nodered.org/t/mysql-array-or-arrays-to-line-chart/12976 "2019-07-06T15:35:08Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![shrickus](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/shrickus/32/517_2.png) [@shrickus](https://discourse.nodered.org/u/shrickus)\
**Post date:** [10 July 2019 16:59 UTC](https://discourse.nodered.org/t/mysql-array-or-arrays-to-line-chart/12976/7 "2019-07-10T16:59:56Z")

</div>

Your data is already an array of objects, each with the X (captureTime) and Y (kW Used Today) values to be charted. So the restructuring of the payload can be done with a fairly simple JSONata expression inside a `change` node -- something like this:

```auto
[{
    "series": ["kW"],
    "labels": ["kW Used Today"],
    "data": [[payload.{
        "x": captureTime,
        "y": $."kW Used Today"
    }]]
}]

```

---

_[View the full topic](https://discourse.nodered.org/t/mysql-array-or-arrays-to-line-chart/12976)._