# ECharts: set up/save input array **URL:** \ **Category:** General\ **Created:** [27 November 2022 19:59 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335 "2022-11-27T19:59:45Z")\ **Posts on this page:** 20\ **Page:** 1

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [27 November 2022 19:59 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/1 "2022-11-27T19:59:45Z")

Hi there! Trying to plot two daily profit data points ('day" and "total") using line echarts. Everything is prepped, just stuck on the task of setting up and saving the array every 24 hours. Here is the function generating the data: ```auto let time = new Date(new Date().getTime()) msgMessage.payload = {'day':paper_dc, 'total':paper_ch, 'time': time} ``` output: ```auto {"day":"0.38","total":"1.75","time":"2022-11-27T19:42:22.657Z"} ``` and here is the echart template: ```auto

``` The day/total values are continuously updated but at midnight the data point marking the end of day is saved (I assume local file), so the chart is showing two types of data (saved history and current day). Also, doing something wrong when I try to assign data in the chart template to variable - i.e : ```auto let day = [["2018-08-16T10:04:01.339Z",1],["2018-08-17T10:14:13.914Z",-1],["2018-08-18T10:40:03.147Z",2.5],["2018-08-19T11:50:14.335Z",1.5]]' ``` is giving an error. Thanks for your help!! ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [28 November 2022 20:23 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/2 "2022-11-28T20:23:17Z")

`let day = [["2018-08-16T10:04:01.339Z",1],["2018-08-17T10:14:13.914Z",-1],["2018-08-18T10:40:03.147Z",2.5],["2018-08-19T11:50:14.335Z",1.5]]'` \<-- single quote on end not required ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [28 November 2022 20:48 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/3 "2022-11-28T20:48:12Z")

Thank you. How do I get the data from function node into the charts template node? Lets say this is the current payload in the function: msg.payload = {'day':paper\_dc, 'total':paper\_ch, 'time': time}. It needs to be formatted differently as an array? How do I reference it in the template; is it same as in a function (let day = msg.payload)? ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [28 November 2022 22:36 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/4 "2022-11-28T22:36:03Z")

`let day = msg.payload.day` etc, or all together `let {day, total, time} = msg.payload` Not sure what you are looking for as an Array but `Object.entries({"day":"0.38","total":"1.75","time":"2022-11-27T19:42:22.657Z"})` gives ```auto [["day","0.38"],["total","1.75"],["time","2022-11-27T19:42:22.657Z"]] ``` ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [28 November 2022 23:18 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/5 "2022-11-28T23:18:37Z")

So "let day = msg.payload.day" declaration is in the chart template ? If so, I tried it - inside the script section, outside - the chart doesn't render. I am simply trying to plot the two variables (day & total) along time x axis on a line echart. Not sure what payload format should be in the output function (json vs array) and any declaration to reference the variables inside the template seems to break it. ```auto

``` ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [29 November 2022 03:24 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/6 "2022-11-29T03:24:44Z")

I moved data into variables but I cannot figure out how to get the data into the echart template via msg.payload. I understand that I need to incorporate scope function somehow ```auto ``` ```auto

``` ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [29 November 2022 20:40 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/7 "2022-11-29T20:40:45Z")

I do not get a chart but the following does get data from msg.payload into the data property of the series ```auto [{"id":"bb07d5d892b7af94","type":"ui_template","z":"7fdabd9.f693544","group":"1a8c624515376944","name":"","order":1,"width":0,"height":0,"format":"\n\n\n \n

\n\n\n \n\n","storeOutMessages":false,"fwdInMessages":false,"resendOnRefresh":true,"templateScope":"local","className":"","x":1000,"y":1000,"wires":[["631ca95e78c33cf4"]]},{"id":"0b7a1c03b5859ccc","type":"inject","z":"7fdabd9.f693544","name":"","props":[{"p":"payload.day","v":"[[\"2018-08-16T10:04:01.339Z\",1],[\"2018-08-17T10:14:13.914Z\",-1],[\"2018-08-18T10:40:03.147Z\",2.5],[\"2018-08-19T11:50:14.335Z\",1.5]]","vt":"json"},{"p":"payload.total","v":"[[\"2018-08-16T10:04:01.339Z\",2],[\"2018-08-17T10:14:13.914Z\",2.5],[\"2018-08-18T10:40:03.147Z\",3],[\"2018-08-19T11:50:14.335Z\",3.5]]","vt":"json"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"A Chart","x":780,"y":1000,"wires":[["bb07d5d892b7af94"]]},{"id":"631ca95e78c33cf4","type":"debug","z":"7fdabd9.f693544","name":"debug 21","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1240,"y":1000,"wires":[]},{"id":"1a8c624515376944","type":"ui_group","name":"Right","tab":"7e13e6107768d821","order":3,"disp":true,"width":12,"collapse":false,"className":""},{"id":"7e13e6107768d821","type":"ui_tab","name":"CRYPTO","icon":"dashboard","order":7,"disabled":false,"hidden":false}] ``` ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [29 November 2022 21:59 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/8 "2022-11-29T21:59:19Z")

Hi, thanks. The chart renders but it's coming blank. If I uncomment one of the data variables, I see data plotted. ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [29 November 2022 22:33 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/9 "2022-11-29T22:33:06Z")

Try ```auto scope.$watch('msg', function(msg) { if (msg) { // Do something when msg arrives day = msg.payload.day total = msg.payload.total title = msg.topic option.series[0].data = total option.series[1].data = day option.title.text = title myChart.setOption(option, true) } }) ``` It seems the chart needs updating. There may be another way but I do not have the chart instructions ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [30 November 2022 02:59 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/10 "2022-11-30T02:59:05Z")

It's working - thank you. Got unexpectedly stuck on trying to replicate sending the two msg payloads msg.payload.day msg.payload.total from a function (rather than inject node). ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [1 December 2022 03:27 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/11 "2022-12-01T03:27:45Z")

I got it working `msgChart.payload = {"day":[[time,paper_dc]],"total":[[time,roi]]}` thanks! To make this useful l I now need to be able to save these two data points every 24 hours and plot the saved history alongside the daily live value. I read several posts on this but haven't been able to implement. Any help would be greatly appreciated. ```auto

``` ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [1 December 2022 20:24 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/12 "2022-12-01T20:24:47Z")

How often are you publishing this data, and how many data points do you wish to save every 24hrs? And when does the 24 hour period end? ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [1 December 2022 20:35 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/13 "2022-12-01T20:35:44Z")

I am polling every minute to update "today's value", but once the day is over ( say midnight) I want to save the data point - in other words, there is going to be two types of data charted - today's (that is getting updated), and historic (that's saved once every 24 hours). ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [2 December 2022 23:12 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/14 "2022-12-02T23:12:18Z")

Hi, could you help me to do the same with the bar chart. I followed the line chart approach but was only able to get the title. Can't figure out how to send payload data to xAxis and Series. Thanks. ```auto

``` ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [2 December 2022 23:47 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/15 "2022-12-02T23:47:51Z")

```auto option.xAxis.data = xAxisData option.series[0].data = seriesData ``` ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [3 December 2022 02:08 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/16 "2022-12-03T02:08:58Z")

what does the msg payload look like? ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [3 December 2022 17:36 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/17 "2022-12-03T17:36:37Z")

According to the eCharts documentation the option should look something like' ```auto option = { xAxis: { type: 'category', data: ['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'] }, yAxis: { type: 'value' }, series: [ { data: [120, 200, 150, 80, 70, 110, 130], type: 'bar', showBackground: true, backgroundStyle: { color: 'rgba(180, 180, 180, 0.2)' } } ] }; ``` If we use the data array in one off your early posts `[["2018-08-16T10:04:01.339Z",1],["2018-08-17T10:14:13.914Z",-1],["2018-08-18T10:40:03.147Z",2.5],["2018-08-19T11:50:14.335Z",1.5]]` then ```auto let day = [["2018-08-16T10:04:01.339Z",1],["2018-08-17T10:14:13.914Z",-1],["2018-08-18T10:40:03.147Z",2.5],["2018-08-19T11:50:14.335Z",1.5]] let seriesData = [] let xAxisData = [] day.forEach(element => {xAxisData = [...xAxisData, element[0]] seriesData = [...seriesData, element[1]] } ) msg.payload = [seriesData, xAxisData] //msg.payload[0] should be an Array [1,-1,2.5,1.5] // and msg.payload[1] should also be an Array ["2018-08-16T10:04:01.339Z","2018-08-17T10:14:13.914Z","2018-08-18T10:40:03.147Z","2018-08-19T11:50:14.335Z"] //then option.series[0].data = msg.payload[0] option.xAxis.data = msg.payload[1] ``` ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [3 December 2022 19:21 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/18 "2022-12-03T19:21:32Z")

Doing something wrong: My xAxis category data is [1, 1.5, 2, 2.5] My corresponding yAxis/Series data "profit" is [2, -1, 3, -2] TEMPLATE: In your example why is "profit" defined with specific values? ```auto

``` FUNCTION ```auto msg.payload = [[2,"1"],[-1, "1.5"],[3, "2"],[-2,"2.5"]] return msg; ``` ---

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\ **Post date:** [3 December 2022 23:54 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/19 "2022-12-03T23:54:31Z")

> [@interscope101](#): > > ```auto > let profit = [[2,"1"],[-1, "1.5"],[3, "2"],[-2,"2.5"]] > > profit.forEach(element => {xAxisData = [...xAxisData, element[0]] > seriesData = [...seriesData, element[1]] > } > ) > > let seriesData = [] > let xAxisData = [] > > msg.payload = [seriesData, xAxisData] > > ``` should be ```auto let profit = [[2,"1"],[-1, "1.5"],[3, "2"],[-2,"2.5"]] let seriesData = [] let xAxisData = [] profit.forEach(element => {xAxisData = [...xAxisData, element[1]] seriesData = [...seriesData, element[0]] } ) msg.payload = [seriesData, xAxisData] ``` > TEMPLATE: > In your example why is "profit" defined with specific values? No idea what this refers to, I have never mentioned 'profit' before. ---

**Author:** ![interscope101](https://avatars.discourse-cdn.com/v4/letter/i/a88e4f/32.png) [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Post date:** [4 December 2022 00:02 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335/20 "2022-12-04T00:02:38Z")

> [@Buckskin](#): > > `let day = [["2018-08-16T10:04:01.339Z",1],["2018-08-17T10:14:13.914Z",-1],["2018-08-18T10:40:03.147Z",2.5],["2018-08-19T11:50:14.335Z",1.5]]` I changed "day" to "profit"; you have: `let day = [["2018-08-16T10:04:01.339Z",1],["2018-08-17T10:14:13.914Z",-1],["2018-08-18T10:40:03.147Z",2.5],["2018-08-19T11:50:14.335Z",1.5]]` I don't understand why specific values are being set within the template. [Next page](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335.md?page=2)