# With dashboard Chart node collect the data and store it
**URL:** https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433
**Category:** Dashboard
**Created:** [4 September 2020 07:11 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433 "2020-09-04T07:11:53Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@rubeng0182](https://discourse.nodered.org/u/rubeng0182)
#### Post date: [4 September 2020 07:11 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/1 "2020-09-04T07:11:54Z")
Hello, i have been trying to store chart data on my RPI4, but i havent been able to do so.
i wanna get it in excel or any other handy file, that way the dates and the data is clear to see.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [4 September 2020 07:56 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/2 "2020-09-04T07:56:29Z")
Welcome to the forum @rubeng0182
I think you need to clarify your requirements a bit. Do you mean you want to continuously send the process data to a spreadsheet, or do you want to let it build up in the chart and then press a button to send the current chart to the spreadsheet, or something else?
It might help if you explain what your end goal is. Do you want to produce reports from the data or be able to show historic data on a chart and be able to select a particular time range to look at, or what?
---
### Author:  [@rubeng0182](https://discourse.nodered.org/u/rubeng0182)
#### Post date: [4 September 2020 07:58 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/3 "2020-09-04T07:58:58Z")
hello @Colin , thanks for responding.
i'm looking for a way to store sensor data from a chart, i think live will be the best option. or like saving every hour.
i want to see the historic data and analyse it on another platform called sibyl, or being able to show and check it our self.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [4 September 2020 08:15 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/4 "2020-09-04T08:15:38Z")
> [@rubeng0182](#):
>
> i think live will be the best option
OK, so nothing to do with the dashboard chart then, you just want to collect live data and pass it to your other system.
Pretty much any format of output is possible, so if you first define exactly what you want to generate then I am sure someone will help. You might start by looking at what would be easiest for sybil to pick up. Have you got a link to the information for Sybil? I couldn't find anything obvious. Can it pick up data via MQTT for example?
---
### Author:  [@rubeng0182](https://discourse.nodered.org/u/rubeng0182)
#### Post date: [4 September 2020 08:17 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/5 "2020-09-04T08:17:38Z")
my idea is to collect the chart data or regular data from the sensor and put it in an spread sheet with time and date for every sensor data point
[https://sibylplatform.com/](https://sibylplatform.com/)
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [4 September 2020 08:23 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/6 "2020-09-04T08:23:02Z")
In that page they say...
> We use communication protocols such as MQTT, LoraWAN, Modbus etc to transfer your data from the sensors to the servers.
So why bother with files? Just send the values via MQTT
---
### Author:  [@rubeng0182](https://discourse.nodered.org/u/rubeng0182)
#### Post date: [4 September 2020 08:37 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/7 "2020-09-04T08:37:31Z")
that sounds like a good idea. whats the best way to the sensor data with a time value. and then sending it through
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [4 September 2020 09:09 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/8 "2020-09-04T09:09:01Z")
Learn node-red. Learn mqtt. Read the extensive node-red docs. Do some of the of node-red cookbook examples. Watch the hundreds of videos on node-red + MQTT.
I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). It is by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in less than an hour. A small investment for a lot of gain.
---
### Author:  [@rubeng0182](https://discourse.nodered.org/u/rubeng0182)
#### Post date: [4 September 2020 09:09 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/9 "2020-09-04T09:09:31Z")
thank you
---
### Author:  [@rubeng0182](https://discourse.nodered.org/u/rubeng0182)
#### Post date: [4 September 2020 09:45 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/10 "2020-09-04T09:45:19Z")
How can i convert the data from the dashboard chart to readable data with the time and date.
@Colin @Steve-Mcl
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [4 September 2020 09:56 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/11 "2020-09-04T09:56:18Z")
I thought you said you were going to use live data rather than get it from the chart. That is much easier.
In addition if you are sending it via mqtt you don't want readable data you want javascript timestamps and numbers. But if you are sending live data you don't need timestamps at all as the time is Now.
If you don't know about MQTT read this excellent tutorial [https://www.hivemq.com/mqtt-essentials/](https://www.hivemq.com/mqtt-essentials/)
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [4 October 2020 09:56 UTC](https://discourse.nodered.org/t/with-dashboard-chart-node-collect-the-data-and-store-it/32433/12 "2020-10-04T09:56:32Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.