# Node-RED dashboard chart node with timestamp

**URL:** https://discourse.nodered.org/t/node-red-dashboard-chart-node-with-timestamp/57460
**Category:** Dashboard
**Tags:** node-red-dashboard, database
**Created:** [29 January 2022 13:01 UTC](https://discourse.nodered.org/t/node-red-dashboard-chart-node-with-timestamp/57460 "2022-01-29T13:01:22Z")
**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: [29 January 2022 13:08 UTC](https://discourse.nodered.org/t/node-red-dashboard-chart-node-with-timestamp/57460/2 "2022-01-29T13:08:36Z")

</div>

The guide does go into detail and the information is there. The issue is there is no one solution when it comes to displaying data - everyone has their own requirements and everyone's data is different.

Here is a flow I wrote that attempts to figure it out for you...

> [@I need help, chart-ui from select sql server](https://discourse.nodered.org/t/i-need-help-chart-ui-from-select-sql-server/46633/31):
>
> Here is a dynamic solution that works for most SQL data arrays... I have adapted it to show you how it can work for you... [image] [{"id":"a80817a3d567f813","type":"inject","z":"553814a2.1248ec","name":"Fake DB data","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"LocalCol\":\"2020-11-18 18:25:48.906\",\"PS3 Output Temp\":21.3},{\"LocalCol\":\"2020-11-18 18:16:23.957\",\"PS3 Output Temp\":21.6},{\"LocalCol\":…

Be sure to read it through and check the link inside that post. You'll likely have to set some field names in the function (I forget)

---

_[View the full topic](https://discourse.nodered.org/t/node-red-dashboard-chart-node-with-timestamp/57460)._