# Node-Red / sqlite / Charts

**URL:** <https://discourse.nodered.org/t/node-red-sqlite-charts/45251>\
**Category:** General\
**Created:** [6 May 2021 07:37 UTC](https://discourse.nodered.org/t/node-red-sqlite-charts/45251 "2021-05-06T07:37:04Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [6 May 2021 08:39 UTC](https://discourse.nodered.org/t/node-red-sqlite-charts/45251/2 "2021-05-06T08:39:51Z")

</div>

> [@Harakaio](#):
>
> From sqlite I receive this: Pic1&2.  
> Pic1:

If you change your SQL QUERY to only return the `timestamp` and `value` you can feed it into [this function](https://discourse.nodered.org/t/dynamic-series-identification-from-message-send-data-to-chart/36682/5) & it will do most of the work for you. NOTE: it expectes `timestamp` not `Timestamp` - you can either edit the function or change the query (e.g. `select Timestamp as timestamp`)

---

_[View the full topic](https://discourse.nodered.org/t/node-red-sqlite-charts/45251)._