# Need help building bar chart from sqlite3 data

**URL:** <https://discourse.nodered.org/t/need-help-building-bar-chart-from-sqlite3-data/46197>\
**Category:** Dashboard\
**Created:** [25 May 2021 08:36 UTC](https://discourse.nodered.org/t/need-help-building-bar-chart-from-sqlite3-data/46197 "2021-05-25T08:36:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![testpaul999](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/testpaul999/32/42376_2.png) [@testpaul999](https://discourse.nodered.org/u/testpaul999)\
**Post date:** [25 May 2021 08:36 UTC](https://discourse.nodered.org/t/need-help-building-bar-chart-from-sqlite3-data/46197/1 "2021-05-25T08:36:50Z")

</div>

Hello,

I'm a total newbie and can't find a solution form my wishes.

i won’t have a bar chart with my historical data.  
sqlite\> SELECT \* from daten\_gestern  
…\> ;  
1621615512513|0.14  
1621636200019|  
1621722600020|  
1621809000143|  
1621895400012|  
sqlite\>

this is for test, not real data but i have one data point per day and I’m unable to find a way bring this in a bar chart.  
triggers once per day.  
can anyone give me a hint, pls.

thx and regards

sorry my bad English it's not my native language.. 😉

---

<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:** [24 June 2021 08:36 UTC](https://discourse.nodered.org/t/need-help-building-bar-chart-from-sqlite3-data/46197/2 "2021-06-24T08:36:55Z")

</div>

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