I am new to node-red and looking for some assistance here. I am running a SQL statement to get two fields returned from a table: customer (string) and storage size (integer). select trim(CUSTOMER) as "CUSTOMER",DISK_SPACE_USED from stats where run_date >= current date I return 46 data sets into 1…

I was able to work it out. This displays the value 0 of both arrays. Thanks for your help @Colin !! **Function Node:** var m = {}; m.data=[]; m.labels=[]; var datatemp=[]; msg.payload.forEach(function(row) { datatemp.push(parseFloat(row.DISK_SPACE_USED)); m.labels.push(row.CUSTOMER…

thebeardedgeek 22 January 2021 20:36 11

@E1cid Thank you for the reply. This would more than likely work but I wanted to try to stick with the system supplied node graphs.

Topic		Replies	Views
Help with sending an array to a chart General	16	2709	28 September 2021
Need help with line chart Dashboard	30	7992	16 July 2019
Plotting arrays Dashboard	4	3805	26 June 2020
Graph with stored data Dashboard	29	5730	26 October 2020
Handling SQL result set Dashboard	14	2649	23 April 2019

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to break data array into separate charts with data and labels

Related topics