Chart-Node - Can't get chart from database data

Dashboard
1

Hi together,
I try to get data from a MariaDB into a chart-node.
As an example I used the information given at MYSQL Example.
I don't find the mistake, why no data are displayed.
My actual flow, as well as the debug outputs are
flow_Maria_chart.json (4.9 KB)
format data_output.txt (710 Bytes)
mysql_output.txt (687 Bytes)
attached
Maybe somebody can give me a tip, where the mistake is.

Thank you very much in advance
Regards

Martin

2

Compare your data with the format described for line charts in node-red-dashboard/Charts.md at master · node-red/node-red-dashboard · GitHub and you will see there are several discrepancies.
series should be an array.
The data must be in an array of arrays and should be called data.
Your timestamps look to be 1000 times too small. I suspect they are seconds rather than milliseconds.

3

Colin,

thank you very much for your support.
I will check soon.

4

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