Hello, I'm looking for help to resolve the "Bad data inject" error when trying to pull from the sqllite node to the Chart node of the attached flow. My thought is that the array is putting out a 0: and 1: instead of x: and y: [image] Here's the Function (post sqlite query and join) for those tha…

As I pointed out earlier this could be done in the sql query. here is an example, replace the change node with your sqlite node. [{"id":"e5025b32b4af5f4b","type":"ui_form","z":"bf9e1e33.030598","name":"Data points","label":"","group":"1e17cd0b.862863","order":0,"width":0,"height":0,"options":[{"la…

Help with messaging on sqlite DB to dashboard chart

Dashboard

NRdiscrs9393 9 May 2022 18:56 5

I couldn't get this to work. I believe the solution is in the prep function node past the sqlite node by reading this post Dynamic series identification from message, send data to Chart - #5 by Steve-Mcl

My issue is that this level of programming is past my capabilities.

Topic		Replies	Views
Visualize Data from Database to Chart Dashboard	13	1154	20 June 2021
Node-Red / sqlite / Charts General	18	2099	8 May 2021
SQLite Error - Exporting data to sql database General node-red-dashboard	5	294	24 September 2022
SQLite -> Dashboard Graph: I am not getting it Dashboard	4	3100	21 November 2018
2 inputs from a database to 1 chart, what am I doing wrong? General	7	662	27 October 2020

Help with messaging on sqlite DB to dashboard chart

Related topics