How to use array element to define another multi-dimension array?

General
1

Hello, I am stuck with these following code for a while. Thanks in advance for any help!
I try to use msg.payload[i][j].labels[i] to represent msg.payload[i][j].com16_19 and msg.payload[i][j].com16_16.

here is my code

var x= [];
var y=[];
 for(var i = 0; i < msg.payload.length; i++){
     var labels=["com16_19","com16_16"];
     for(var j = 0; j < msg.payload[i].length; j++){
    
y.push(msg.payload[i][j].labels[i]);
x.push(msg.payload[i][j].get_tm);

debug message : TypeError: Cannot read property '0' of undefined

2

Can you show us what a typical payload is and what your expecting the output of your node to produce?

3

Hello, here is the payload looks like. I would output them to chart node. to have multi-series chart.

{"topic":"SELECT com16_16 ,get_tm FROM d_mon_mountr WHERE get_tm >= '2018-9-27 14:37:28' limit 1000 ","_msgid":"65f47323.2aacbc","payload":[[{"com16_19":30,"get_tm":"2018-09-27T18:37:28.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:37:28.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:37:30.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:37:31.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:37:32.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:37:33.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:37:34.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:37:35.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:37:36.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:37:37.000Z"},{"com16_19":10,"get_tm":"2018-09-27T18:37:38.000Z"},{"com16_19":9,"get_tm":"2018-09-27T18:37:39.000Z"},{"com16_19":8,"get_tm":"2018-09-27T18:37:40.000Z"},{"com16_19":7,"get_tm":"2018-09-27T18:37:41.000Z"},{"com16_19":6,"get_tm":"2018-09-27T18:37:43.000Z"},{"com16_19":6,"get_tm":"2018-09-27T18:37:44.000Z"},{"com16_19":5,"get_tm":"2018-09-27T18:37:45.000Z"},{"com16_19":5,"get_tm":"2018-09-27T18:37:46.000Z"},{"com16_19":4,"get_tm":"2018-09-27T18:37:47.000Z"},{"com16_19":26,"get_tm":"2018-09-27T18:37:48.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:37:50.000Z"},{"com16_19":28,"get_tm":"2018-09-27T18:37:50.000Z"},{"com16_19":35,"get_tm":"2018-09-27T18:37:51.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:37:52.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:37:53.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:37:53.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:37:55.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:37:56.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:37:57.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:37:59.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:38:00.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:38:01.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:38:02.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:38:04.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:38:05.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:38:06.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:38:07.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:38:08.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:38:09.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:38:10.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:38:11.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:38:11.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:38:13.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:38:13.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:38:15.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:38:16.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:38:18.000Z"},{"com16_19":10,"get_tm":"2018-09-27T18:38:19.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:38:20.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:38:21.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:38:21.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:38:22.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:38:23.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:38:25.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:38:25.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:38:26.000Z"},{"com16_19":23,"get_tm":"2018-09-27T18:38:27.000Z"},{"com16_19":21,"get_tm":"2018-09-27T18:38:29.000Z"},{"com16_19":19,"get_tm":"2018-09-27T18:38:29.000Z"},{"com16_19":17,"get_tm":"2018-09-27T18:38:31.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:38:33.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:38:34.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:38:35.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:38:36.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:38:37.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:38:38.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:38:39.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:38:40.000Z"},{"com16_19":28,"get_tm":"2018-09-27T18:38:41.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:38:43.000Z"},{"com16_19":23,"get_tm":"2018-09-27T18:38:43.000Z"},{"com16_19":21,"get_tm":"2018-09-27T18:38:44.000Z"},{"com16_19":19,"get_tm":"2018-09-27T18:38:45.000Z"},{"com16_19":17,"get_tm":"2018-09-27T18:38:47.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:38:49.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:38:50.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:38:51.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:38:52.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:38:53.000Z"},{"com16_19":37,"get_tm":"2018-09-27T18:38:53.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:38:55.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:38:56.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:38:57.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:38:58.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:38:59.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:39:00.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:39:01.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:39:02.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:39:04.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:39:05.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:39:06.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:39:08.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:39:09.000Z"},{"com16_19":35,"get_tm":"2018-09-27T18:39:09.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:39:11.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:39:12.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:39:13.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:39:13.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:39:14.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:39:15.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:39:16.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:39:17.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:39:19.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:39:21.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:39:22.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:39:23.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:39:24.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:39:25.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:39:25.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:39:27.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:39:29.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:39:29.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:39:30.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:39:31.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:39:34.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:39:35.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:39:36.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:39:37.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:39:38.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:39:39.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:39:40.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:39:42.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:39:43.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:39:43.000Z"},{"com16_19":37,"get_tm":"2018-09-27T18:39:44.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:39:45.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:39:46.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:39:47.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:39:49.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:39:51.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:39:51.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:39:53.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:39:53.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:39:54.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:39:56.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:39:57.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:39:58.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:39:59.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:40:00.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:40:01.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:40:02.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:40:03.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:40:03.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:40:05.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:40:07.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:40:07.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:40:08.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:40:10.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:40:11.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:40:13.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:40:13.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:40:14.000Z"},{"com16_19":35,"get_tm":"2018-09-27T18:40:15.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:40:16.000Z"},{"com16_19":28,"get_tm":"2018-09-27T18:40:17.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:40:19.000Z"},{"com16_19":21,"get_tm":"2018-09-27T18:40:20.000Z"},{"com16_19":17,"get_tm":"2018-09-27T18:40:22.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:40:23.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:40:24.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:40:25.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:40:26.000Z"},{"com16_19":37,"get_tm":"2018-09-27T18:40:27.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:40:28.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:40:29.000Z"},{"com16_19":28,"get_tm":"2018-09-27T18:40:31.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:40:31.000Z"},{"com16_19":23,"get_tm":"2018-09-27T18:40:33.000Z"},{"com16_19":21,"get_tm":"2018-09-27T18:40:35.000Z"},{"com16_19":19,"get_tm":"2018-09-27T18:40:36.000Z"},{"com16_19":17,"get_tm":"2018-09-27T18:40:37.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:40:37.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:40:39.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:40:40.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:40:41.000Z"},{"com16_19":10,"get_tm":"2018-09-27T18:40:42.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:40:43.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:40:44.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:40:45.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:40:46.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:40:47.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:40:48.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:40:49.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:40:51.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:40:53.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:40:54.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:40:55.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:40:56.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:40:57.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:40:58.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:40:59.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:41:00.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:41:01.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:41:02.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:41:03.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:41:05.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:41:06.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:41:07.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:41:08.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:41:09.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:41:10.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:41:11.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:41:12.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:41:13.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:41:14.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:41:15.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:41:16.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:41:17.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:41:19.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:41:20.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:41:21.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:41:22.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:41:23.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:41:25.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:41:26.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:41:27.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:41:27.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:41:28.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:41:29.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:41:30.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:41:31.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:41:32.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:41:34.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:41:35.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:41:36.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:41:37.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:41:39.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:41:39.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:41:41.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:41:42.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:41:43.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:41:44.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:41:45.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:41:46.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:41:47.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:41:49.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:41:50.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:41:51.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:41:52.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:41:54.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:41:55.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:41:55.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:41:57.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:41:57.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:41:58.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:41:59.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:42:00.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:01.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:42:02.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:42:04.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:42:05.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:42:06.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:42:07.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:42:08.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:42:09.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:42:10.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:42:11.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:42:12.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:13.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:15.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:42:15.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:42:17.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:42:19.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:42:20.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:42:21.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:42:22.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:42:23.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:42:25.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:42:26.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:42:27.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:42:28.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:29.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:42:30.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:31.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:42:32.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:42:34.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:42:35.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:42:36.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:42:37.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:42:38.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:42:39.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:42:41.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:42:41.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:42:42.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:42:44.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:42:45.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:45.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:42:47.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:42:48.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:42:49.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:42:51.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:42:52.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:42:53.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:42:53.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:42:55.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:42:56.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:42:57.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:42:58.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:42:59.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:43:00.000Z"},{"com16_19":26,"get_tm":"2018-09-27T18:43:01.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:43:02.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:43:03.000Z"},{"com16_19":19,"get_tm":"2018-09-27T18:43:05.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:43:05.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:43:07.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:43:08.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:43:09.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:43:09.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:43:11.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:43:12.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:43:13.000Z"},{"com16_19":28,"get_tm":"2018-09-27T18:43:14.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:43:15.000Z"},{"com16_19":23,"get_tm":"2018-09-27T18:43:16.000Z"},{"com16_19":21,"get_tm":"2018-09-27T18:43:17.000Z"},{"com16_19":19,"get_tm":"2018-09-27T18:43:19.000Z"},{"com16_19":17,"get_tm":"2018-09-27T18:43:21.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:43:22.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:43:23.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:43:24.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:43:25.000Z"},{"com16_19":34,"get_tm":"2018-09-27T18:43:26.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:43:27.000Z"},{"com16_19":27,"get_tm":"2018-09-27T18:43:27.000Z"},{"com16_19":25,"get_tm":"2018-09-27T18:43:29.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:43:30.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:43:32.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:43:33.000Z"},{"com16_19":15,"get_tm":"2018-09-27T18:43:34.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:43:35.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:43:36.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:43:37.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:43:38.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:43:39.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:43:40.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:43:41.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:43:43.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:43:44.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:43:45.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:43:47.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:43:49.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:43:49.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:43:50.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:43:51.000Z"},{"com16_19":26,"get_tm":"2018-09-27T18:43:52.000Z"},{"com16_19":24,"get_tm":"2018-09-27T18:43:53.000Z"},{"com16_19":22,"get_tm":"2018-09-27T18:43:54.000Z"},{"com16_19":20,"get_tm":"2018-09-27T18:43:55.000Z"},{"com16_19":18,"get_tm":"2018-09-27T18:43:57.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:43:58.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:43:59.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:44:01.000Z"},{"com16_19":12,"get_tm":"2018-09-27T18:44:02.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:44:03.000Z"},{"com16_19":31,"get_tm":"2018-09-27T18:44:03.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:44:05.000Z"},{"com16_19":35,"get_tm":"2018-09-27T18:44:05.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:44:06.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:44:07.000Z"},{"com16_19":26,"get_tm":"2018-09-27T18:44:08.000Z"},{"com16_19":23,"get_tm":"2018-09-27T18:44:09.000Z"},{"com16_19":21,"get_tm":"2018-09-27T18:44:11.000Z"},{"com16_19":19,"get_tm":"2018-09-27T18:44:11.000Z"},{"com16_19":17,"get_tm":"2018-09-27T18:44:13.000Z"},{"com16_19":16,"get_tm":"2018-09-27T18:44:14.000Z"},{"com16_19":14,"get_tm":"2018-09-27T18:44:15.000Z"},{"com16_19":13,"get_tm":"2018-09-27T18:44:17.000Z"},{"com16_19":11,"get_tm":"2018-09-27T18:44:18.000Z"},{"com16_19":29,"get_tm":"2018-09-27T18:44:19.000Z"},{"com16_19":32,"get_tm":"2018-09-27T18:44:20.000Z"},{"com16_19":30,"get_tm":"2018-09-27T18:44:21.000Z"},{"com16_19":36,"get_tm":"2018-09-27T18:44:22.000Z"},{"com16_19":33,"get_tm":"2018-09-27T18:44:23.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:49.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:50.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:51.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:52.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:53.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:54.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:55.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:56.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:57.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:58.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:53:59.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:00.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:01.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:02.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:03.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:04.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:05.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:06.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:07.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:08.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:09.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:10.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:11.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:12.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:13.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:14.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:15.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:16.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:17.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:18.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:20.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:21.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:22.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:23.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:24.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:25.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:26.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:27.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:28.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:29.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:30.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:31.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:32.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:33.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:34.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:35.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:36.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:37.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:38.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:39.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:40.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:41.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:42.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:43.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:44.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:45.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:46.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:47.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:48.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:49.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:50.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:51.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:52.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:53.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:54.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:55.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:56.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:57.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:58.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:54:59.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:00.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:01.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:02.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:03.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:04.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:05.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:06.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:07.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:08.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:09.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:10.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:11.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:12.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:13.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:14.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:15.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:16.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:17.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:18.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:19.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:20.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:21.000Z"},{"com16_16":0,"get_tm":"2018-09-27T18:55:22.000Z"}]]}

thanks for replying
Alex

4

So for that incoming payload - what do you want the outgoing payload to be?

5

Hi.
it should be two arrays in this case
one has the key like com16_19 or another name , value of payloads.
other has the key like com16_16 or another name, value of payloads.
in this way, I can compare the two line chart on one screen.
Alex

6

So { "com16_19" : [0,10,19,4,12 etc] } and another one { "com16_16" : [18,3,12,4,20 etc] } ?

or just two plain arrays [0,10,19,4,12 etc] and [18,3,12,4,20 etc] ?

7

If I only work with one set of data, I can get the chart.
the output is like this

[{"series":"Transfer","data":[[30,27,24,22,18,16,15,13,12,11]],"labels":["2018-09-27T18:37:28.000Z","2018-09-27T18:37:28.000Z","2018-09-27T18:37:30.000Z","2018-09-27T18:37:31.000Z","2018-09-27T18:37:32.000Z","2018-09-27T18:37:33.000Z","2018-09-27T18:37:34.000Z","2018-09-27T18:37:35.000Z","2018-09-27T18:37:36.000Z","2018-09-27T18:37:37.000Z"]}]

it will draw one line on the chart.

I want to be able draw two or multiple lines on the chart.
so I expect the result would be array with two elements.

Capture1

1 Like
8 
	for(var i = 0; i < msg.payload.length; i++){
	    for (var j=0; j<msg.payload[i].length; j++){
    	    y.push(msg.payload[i][j].labels[i].toString());
    	    x.push(msg.payload[i][j].get_tm);
        chart=[{"data":[y],"labels":x}];
	}   
 
 chat2.push({series: series[i], values:chart});
}
9

Hi Alex

Are you still stuck on this problem?

I only got involved in your query in order to get more information from you on what your data was and what you wanted to do with it

I was hoping someone with more knowledge would then join in to offer suggestions on what to do but no-one has

Maybe they'll see this and join in :slight_smile:
Simon

10

Simon
thanks!

I am still working on it.

it seems key() and map() can do the trick.

still learning, cheers!

Alex

11

I think you are on the right way but please allow me to provide a possible solution. I am pretty much sure it can be improved, probably using a reduce method, but I would not have the time right now to work on that. Also it is much simpler to understand a filter + map than understanding a reduce.

This flow uses a function node to create the required arrays. It seems huge and the reason is that there is a dataset hardcoded. You will want to replace the first two nodes (inject + Load Dataset) to suit your flow.

r-02
r-021118Ă—182 15.9 KB

It is not possible to visualize the second series as all values are zero.

r-01
r-01821Ă—477 20.9 KB

Flow:

Edit: small change applied to make easier to visualize the array data in the debug node.

[{"id":"d682c0e4.416b2","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"c76b10e2.b2eae","type":"ui_chart","z":"d682c0e4.416b2","name":"","group":"2257ffde.e0372","order":0,"width":"12","height":"6","label":"{{msg.label}}","chartType":"line","legend":"true","xformat":"HH:mm:ss","interpolate":"step","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"1","removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"x":870,"y":300,"wires":[[],[]]},{"id":"1894f658.8b944a","type":"inject","z":"d682c0e4.416b2","name":"","topic":"","payload":"[]","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":690,"y":300,"wires":[["c76b10e2.b2eae"]]},{"id":"a3153738.67d028","type":"change","z":"d682c0e4.416b2","name":"Load Dataset","rules":[{"t":"set","p":"dataset","pt":"msg","to":"{\"topic\":\"SELECT com16_16 ,get_tm FROM d_mon_mountr WHERE get_tm >= '2018-9-27 14:37:28' limit 1000 \",\"_msgid\":\"65f47323.2aacbc\",\"payload\":[[{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:37:28.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:37:28.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:37:30.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:37:31.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:37:32.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:37:33.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:37:34.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:37:35.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:37:36.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:37:37.000Z\"},{\"com16_19\":10,\"get_tm\":\"2018-09-27T18:37:38.000Z\"},{\"com16_19\":9,\"get_tm\":\"2018-09-27T18:37:39.000Z\"},{\"com16_19\":8,\"get_tm\":\"2018-09-27T18:37:40.000Z\"},{\"com16_19\":7,\"get_tm\":\"2018-09-27T18:37:41.000Z\"},{\"com16_19\":6,\"get_tm\":\"2018-09-27T18:37:43.000Z\"},{\"com16_19\":6,\"get_tm\":\"2018-09-27T18:37:44.000Z\"},{\"com16_19\":5,\"get_tm\":\"2018-09-27T18:37:45.000Z\"},{\"com16_19\":5,\"get_tm\":\"2018-09-27T18:37:46.000Z\"},{\"com16_19\":4,\"get_tm\":\"2018-09-27T18:37:47.000Z\"},{\"com16_19\":26,\"get_tm\":\"2018-09-27T18:37:48.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:37:50.000Z\"},{\"com16_19\":28,\"get_tm\":\"2018-09-27T18:37:50.000Z\"},{\"com16_19\":35,\"get_tm\":\"2018-09-27T18:37:51.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:37:52.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:37:53.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:37:53.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:37:55.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:37:56.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:37:57.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:37:59.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:38:00.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:38:01.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:38:02.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:38:04.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:38:05.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:38:06.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:38:07.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:38:08.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:38:09.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:38:10.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:38:11.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:38:11.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:38:13.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:38:13.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:38:15.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:38:16.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:38:18.000Z\"},{\"com16_19\":10,\"get_tm\":\"2018-09-27T18:38:19.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:38:20.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:38:21.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:38:21.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:38:22.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:38:23.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:38:25.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:38:25.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:38:26.000Z\"},{\"com16_19\":23,\"get_tm\":\"2018-09-27T18:38:27.000Z\"},{\"com16_19\":21,\"get_tm\":\"2018-09-27T18:38:29.000Z\"},{\"com16_19\":19,\"get_tm\":\"2018-09-27T18:38:29.000Z\"},{\"com16_19\":17,\"get_tm\":\"2018-09-27T18:38:31.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:38:33.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:38:34.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:38:35.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:38:36.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:38:37.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:38:38.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:38:39.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:38:40.000Z\"},{\"com16_19\":28,\"get_tm\":\"2018-09-27T18:38:41.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:38:43.000Z\"},{\"com16_19\":23,\"get_tm\":\"2018-09-27T18:38:43.000Z\"},{\"com16_19\":21,\"get_tm\":\"2018-09-27T18:38:44.000Z\"},{\"com16_19\":19,\"get_tm\":\"2018-09-27T18:38:45.000Z\"},{\"com16_19\":17,\"get_tm\":\"2018-09-27T18:38:47.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:38:49.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:38:50.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:38:51.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:38:52.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:38:53.000Z\"},{\"com16_19\":37,\"get_tm\":\"2018-09-27T18:38:53.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:38:55.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:38:56.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:38:57.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:38:58.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:38:59.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:39:00.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:39:01.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:39:02.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:39:04.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:39:05.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:39:06.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:39:08.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:39:09.000Z\"},{\"com16_19\":35,\"get_tm\":\"2018-09-27T18:39:09.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:39:11.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:39:12.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:39:13.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:39:13.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:39:14.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:39:15.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:39:16.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:39:17.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:39:19.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:39:21.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:39:22.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:39:23.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:39:24.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:39:25.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:39:25.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:39:27.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:39:29.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:39:29.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:39:30.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:39:31.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:39:34.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:39:35.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:39:36.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:39:37.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:39:38.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:39:39.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:39:40.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:39:42.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:39:43.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:39:43.000Z\"},{\"com16_19\":37,\"get_tm\":\"2018-09-27T18:39:44.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:39:45.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:39:46.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:39:47.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:39:49.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:39:51.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:39:51.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:39:53.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:39:53.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:39:54.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:39:56.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:39:57.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:39:58.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:39:59.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:40:00.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:40:01.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:40:02.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:40:03.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:40:03.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:40:05.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:40:07.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:40:07.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:40:08.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:40:10.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:40:11.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:40:13.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:40:13.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:40:14.000Z\"},{\"com16_19\":35,\"get_tm\":\"2018-09-27T18:40:15.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:40:16.000Z\"},{\"com16_19\":28,\"get_tm\":\"2018-09-27T18:40:17.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:40:19.000Z\"},{\"com16_19\":21,\"get_tm\":\"2018-09-27T18:40:20.000Z\"},{\"com16_19\":17,\"get_tm\":\"2018-09-27T18:40:22.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:40:23.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:40:24.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:40:25.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:40:26.000Z\"},{\"com16_19\":37,\"get_tm\":\"2018-09-27T18:40:27.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:40:28.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:40:29.000Z\"},{\"com16_19\":28,\"get_tm\":\"2018-09-27T18:40:31.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:40:31.000Z\"},{\"com16_19\":23,\"get_tm\":\"2018-09-27T18:40:33.000Z\"},{\"com16_19\":21,\"get_tm\":\"2018-09-27T18:40:35.000Z\"},{\"com16_19\":19,\"get_tm\":\"2018-09-27T18:40:36.000Z\"},{\"com16_19\":17,\"get_tm\":\"2018-09-27T18:40:37.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:40:37.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:40:39.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:40:40.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:40:41.000Z\"},{\"com16_19\":10,\"get_tm\":\"2018-09-27T18:40:42.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:40:43.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:40:44.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:40:45.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:40:46.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:40:47.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:40:48.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:40:49.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:40:51.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:40:53.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:40:54.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:40:55.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:40:56.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:40:57.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:40:58.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:40:59.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:41:00.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:41:01.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:41:02.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:41:03.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:41:05.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:41:06.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:41:07.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:41:08.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:41:09.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:41:10.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:41:11.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:41:12.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:41:13.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:41:14.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:41:15.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:41:16.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:41:17.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:41:19.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:41:20.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:41:21.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:41:22.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:41:23.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:41:25.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:41:26.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:41:27.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:41:27.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:41:28.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:41:29.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:41:30.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:41:31.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:41:32.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:41:34.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:41:35.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:41:36.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:41:37.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:41:39.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:41:39.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:41:41.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:41:42.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:41:43.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:41:44.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:41:45.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:41:46.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:41:47.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:41:49.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:41:50.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:41:51.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:41:52.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:41:54.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:41:55.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:41:55.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:41:57.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:41:57.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:41:58.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:41:59.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:42:00.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:01.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:42:02.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:42:04.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:42:05.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:42:06.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:42:07.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:42:08.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:42:09.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:42:10.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:42:11.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:42:12.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:13.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:15.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:42:15.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:42:17.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:42:19.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:42:20.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:42:21.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:42:22.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:42:23.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:42:25.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:42:26.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:42:27.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:42:28.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:29.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:42:30.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:31.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:42:32.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:42:34.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:42:35.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:42:36.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:42:37.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:42:38.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:42:39.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:42:41.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:42:41.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:42:42.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:42:44.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:42:45.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:45.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:42:47.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:42:48.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:42:49.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:42:51.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:42:52.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:42:53.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:42:53.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:42:55.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:42:56.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:42:57.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:42:58.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:42:59.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:43:00.000Z\"},{\"com16_19\":26,\"get_tm\":\"2018-09-27T18:43:01.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:43:02.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:43:03.000Z\"},{\"com16_19\":19,\"get_tm\":\"2018-09-27T18:43:05.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:43:05.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:43:07.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:43:08.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:43:09.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:43:09.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:43:11.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:43:12.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:43:13.000Z\"},{\"com16_19\":28,\"get_tm\":\"2018-09-27T18:43:14.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:43:15.000Z\"},{\"com16_19\":23,\"get_tm\":\"2018-09-27T18:43:16.000Z\"},{\"com16_19\":21,\"get_tm\":\"2018-09-27T18:43:17.000Z\"},{\"com16_19\":19,\"get_tm\":\"2018-09-27T18:43:19.000Z\"},{\"com16_19\":17,\"get_tm\":\"2018-09-27T18:43:21.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:43:22.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:43:23.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:43:24.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:43:25.000Z\"},{\"com16_19\":34,\"get_tm\":\"2018-09-27T18:43:26.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:43:27.000Z\"},{\"com16_19\":27,\"get_tm\":\"2018-09-27T18:43:27.000Z\"},{\"com16_19\":25,\"get_tm\":\"2018-09-27T18:43:29.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:43:30.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:43:32.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:43:33.000Z\"},{\"com16_19\":15,\"get_tm\":\"2018-09-27T18:43:34.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:43:35.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:43:36.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:43:37.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:43:38.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:43:39.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:43:40.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:43:41.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:43:43.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:43:44.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:43:45.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:43:47.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:43:49.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:43:49.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:43:50.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:43:51.000Z\"},{\"com16_19\":26,\"get_tm\":\"2018-09-27T18:43:52.000Z\"},{\"com16_19\":24,\"get_tm\":\"2018-09-27T18:43:53.000Z\"},{\"com16_19\":22,\"get_tm\":\"2018-09-27T18:43:54.000Z\"},{\"com16_19\":20,\"get_tm\":\"2018-09-27T18:43:55.000Z\"},{\"com16_19\":18,\"get_tm\":\"2018-09-27T18:43:57.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:43:58.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:43:59.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:44:01.000Z\"},{\"com16_19\":12,\"get_tm\":\"2018-09-27T18:44:02.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:44:03.000Z\"},{\"com16_19\":31,\"get_tm\":\"2018-09-27T18:44:03.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:44:05.000Z\"},{\"com16_19\":35,\"get_tm\":\"2018-09-27T18:44:05.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:44:06.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:44:07.000Z\"},{\"com16_19\":26,\"get_tm\":\"2018-09-27T18:44:08.000Z\"},{\"com16_19\":23,\"get_tm\":\"2018-09-27T18:44:09.000Z\"},{\"com16_19\":21,\"get_tm\":\"2018-09-27T18:44:11.000Z\"},{\"com16_19\":19,\"get_tm\":\"2018-09-27T18:44:11.000Z\"},{\"com16_19\":17,\"get_tm\":\"2018-09-27T18:44:13.000Z\"},{\"com16_19\":16,\"get_tm\":\"2018-09-27T18:44:14.000Z\"},{\"com16_19\":14,\"get_tm\":\"2018-09-27T18:44:15.000Z\"},{\"com16_19\":13,\"get_tm\":\"2018-09-27T18:44:17.000Z\"},{\"com16_19\":11,\"get_tm\":\"2018-09-27T18:44:18.000Z\"},{\"com16_19\":29,\"get_tm\":\"2018-09-27T18:44:19.000Z\"},{\"com16_19\":32,\"get_tm\":\"2018-09-27T18:44:20.000Z\"},{\"com16_19\":30,\"get_tm\":\"2018-09-27T18:44:21.000Z\"},{\"com16_19\":36,\"get_tm\":\"2018-09-27T18:44:22.000Z\"},{\"com16_19\":33,\"get_tm\":\"2018-09-27T18:44:23.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:49.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:50.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:51.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:52.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:53.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:54.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:55.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:56.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:57.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:58.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:53:59.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:00.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:01.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:02.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:03.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:04.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:05.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:06.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:07.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:08.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:09.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:10.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:11.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:12.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:13.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:14.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:15.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:16.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:17.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:18.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:20.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:21.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:22.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:23.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:24.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:25.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:26.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:27.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:28.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:29.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:30.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:31.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:32.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:33.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:34.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:35.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:36.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:37.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:38.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:39.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:40.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:41.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:42.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:43.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:44.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:45.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:46.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:47.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:48.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:49.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:50.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:51.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:52.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:53.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:54.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:55.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:56.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:57.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:58.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:54:59.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:00.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:01.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:02.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:03.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:04.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:05.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:06.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:07.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:08.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:09.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:10.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:11.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:12.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:13.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:14.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:15.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:16.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:17.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:18.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:19.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:20.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:21.000Z\"},{\"com16_16\":0,\"get_tm\":\"2018-09-27T18:55:22.000Z\"}]]}","tot":"json"},{"t":"set","p":"payload","pt":"msg","to":"dataset.payload[0]","tot":"msg"},{"t":"delete","p":"dataset","pt":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":310,"y":220,"wires":[["82da3d8a.c0b8c"]]},{"id":"3ff5f635.3ea9fa","type":"inject","z":"d682c0e4.416b2","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":220,"wires":[["a3153738.67d028"]]},{"id":"82da3d8a.c0b8c","type":"function","z":"d682c0e4.416b2","name":"Filter and map","func":"\nfunction f_19(ele) {\n    return (\"com16_19\" in ele);\n}\n\nfunction f_16(ele) {\n    return (\"com16_16\" in ele);\n}\n\nfunction m_16(ele) {\n    return ({\"x\":ele.get_tm, \"y\":ele.com16_16})\n}\n\nfunction m_19(ele) {\n    return ({\"x\":ele.get_tm, \"y\":ele.com16_19})\n}\n\nlet arr_16 = msg.payload\n  .filter(f_16)\n  .map(m_16);\n\nlet arr_19 = msg.payload\n  .filter(f_19)\n  .map(m_19);\n\n\n\nmsg.arr16 = arr_16;\nmsg.arr19 = arr_19;\n\nreturn msg;","outputs":1,"noerr":0,"x":500,"y":220,"wires":[["4a73d89b.837a28","d42a4d4e.9d828"]]},{"id":"d42a4d4e.9d828","type":"debug","z":"d682c0e4.416b2","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":690,"y":160,"wires":[]},{"id":"4a73d89b.837a28","type":"function","z":"d682c0e4.416b2","name":"Setup Chart","func":"data = [];\nseries = [\"com16_16\", \"com16_19\"];\nlabels = [\"com16_16\", \"com16_19\"];\n\ndata.push(msg.arr16);\ndata.push(msg.arr19);\n\nmsg.payload = [{\"series\":series, \"data\":data,\"labels\": labels}];\n\nreturn msg;","outputs":1,"noerr":0,"x":710,"y":220,"wires":[["c76b10e2.b2eae"]]},{"id":"2257ffde.e0372","type":"ui_group","z":"","name":"Group 1","tab":"7ca87b7b.b32a64","disp":true,"width":"12","collapse":false},{"id":"7ca87b7b.b32a64","type":"ui_tab","z":"","name":"Tab1","icon":"dashboard"}]
12

Andrei
Hello!
Thank you very much about the flow you showed me!
It helped me understood a lot better now.
I made some progress as below.!

line%20chart
line chart.JPG1340Ă—626 71.5 KB

here is the code I used

[{"id":"f21c8a97.fb6a98","type":"ui_chart","z":"b13d46a7.b0ff78","name":"Chart search","group":"a9e9a2a2.000ee","order":1,"width":"6","height":"6","label":"chart search","chartType":"line","legend":"true","xformat":"auto","interpolate":"step","nodata":"No data","dot":false,"ymin":"0","ymax":"50","removeOlder":"60","removeOlderPoints":"3600","removeOlderUnit":"60","cutout":0,"useOneColor":false,"colors":["#bb178a","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#000000"],"useOldStyle":false,"x":554.047607421875,"y":284.6190185546875,"wires":[[],[]]},{"id":"9267e997.17be28","type":"mysql","z":"b13d46a7.b0ff78","mydb":"aae264f0.90e1d8","name":"IoTdatabase","x":413.3929138183594,"y":189.3411865234375,"wires":[["81639fe0.2dd9f"]],"inputLabels":["select * from v_alarms_hdr order by alarm_id desc limit 1"]},{"id":"b94f5db0.4aab","type":"ui_date_picker","z":"b13d46a7.b0ff78","name":"","label":"Date Picker","group":"78d8a860.7260b8","order":1,"width":"2","height":"1","passthru":false,"topic":"select date","x":81,"y":112.54763793945312,"wires":[["afb3a33c.13eb9"]]},{"id":"afb3a33c.13eb9","type":"function","z":"b13d46a7.b0ff78","name":"Flow set Date","func":"flow.set(\"start_date_glo\",msg.payload);\n","outputs":1,"noerr":0,"x":251.81747436523438,"y":108.73018264770508,"wires":[[]]},{"id":"5789d5b2.c1713c","type":"function","z":"b13d46a7.b0ff78","name":"query","func":"//var select_date=flow.get(\"start_date_glo\");\nvar st=flow.get(\"start_T\");\nvar et=flow.get(\"end_T\");\n//var start_date= select_date - 2500;\n//var end_date=select_date +2500;\nvar start_date = new Date(st).toLocaleString();\nvar end_date = new Date(et).toLocaleString();\n//var start_date = new Date(select_date).toLocaleString();\n//var end_date = new Date(select_date + 360000).toLocaleString();\n// This will handle any device and any attribute as long as it is in the DB\n// var Week  = 604800000 ; //7 Days\n// var Day   =  86400000 ; // 1 Days\n// var d = new Date();\n// var epoch = d.getTime();\n// var fromdate = epoch - Day;\n// var enddate = epoch;\nvar output = [];\n\nfor (var property in msg.payload) {\n    if (msg.payload.hasOwnProperty(property)) {\n        //output.push({ payload: property + \" has value \"+msg.payload[property] });\n        if (msg.payload[property]) {\n            var parts = property.split(\"/\");\n            output.push({ topic: \"SELECT \" + parts[1] +\" as y, get_tm as x FROM \" +parts[0]+\" WHERE get_tm >= '\" + start_date+ \"' and get_tm <'\" +end_date+\"'\"});\n            }\n        }\n    }\n\n\noutput[output.length-1].complete=true;\n\nreturn [ output ];\n//var y= {payload:msg.payload};\n//y.topic= \"SELECT get_tm,com16_9 FROM iot_msgs.d_mon_mountr where get_tm >'\" + start_date + \"'and get_tm <'\" + end_date + \"'order by get_tm asc;\"\n//var z= {topic:y.topic.replace(/input/g,y.payload)};\n//return y;","outputs":1,"noerr":0,"x":245.84925842285156,"y":189.55557250976562,"wires":[["9267e997.17be28"]]},{"id":"7910aa08.b2ee64","type":"ui_form","z":"b13d46a7.b0ff78","name":"Data points","label":"","group":"78d8a860.7260b8","order":4,"width":"6","height":"1","options":[{"label":"Transfer Servo Torque","value":"d_mon_mountr/com16_19","type":"checkbox","required":false},{"label":"Arm Servo Torque","value":"d_mon_mountr/com16_16","type":"checkbox","required":false}],"formValue":{"d_mon_mountr/com16_19":false,"d_mon_mountr/com16_16":false},"payload":"","topic":"","x":81,"y":189.46829223632812,"wires":[["5789d5b2.c1713c"]]},{"id":"ab37106e.619bf","type":"ui_slider","z":"b13d46a7.b0ff78","name":"","label":"Hour meter","group":"78d8a860.7260b8","order":2,"width":"4","height":"1","passthru":true,"topic":"changeTime","min":0,"max":"24","step":"0.1","x":76.88888549804688,"y":55.22223663330078,"wires":[["31959ed5.6d0cd2"]]},{"id":"31959ed5.6d0cd2","type":"function","z":"b13d46a7.b0ff78","name":"Flow Set Time","func":"var t= flow.get(\"start_date_glo\");\nvar tweak=msg.payload;\nvar hours = (tweak * 60) * 60 * 1000;\nif ( tweak !== 0) {var start_t= t+hours}\nelse {start_t=t}\nvar end_t= start_t +360000;\nflow.set(\"start_T\",start_t);\nflow.set(\"end_T\",end_t);\nmsg.payload=new Date(start_t).toLocaleString();\nreturn msg;\n","outputs":1,"noerr":0,"x":257.4444580078125,"y":55.44440460205078,"wires":[["cd3a7bad.937278"]]},{"id":"cd3a7bad.937278","type":"ui_text","z":"b13d46a7.b0ff78","group":"78d8a860.7260b8","order":3,"width":"2","height":"1","name":"","label":"Start time is","format":"{{msg.payload}}","layout":"row-left","x":413.1111145019531,"y":52,"wires":[]},{"id":"903031fd.52e62","type":"function","z":"b13d46a7.b0ff78","name":"Draw two line chart ( working version)","func":"\nvar y= [];\nvar series = [\"transfer\",\"arm\"]\nfor(var i = 0; i < msg.payload.length; i++){\n    y.push(msg.payload[i]);\n}\n\n msg.payload = [{\n \"series\": series,\n \"data\": y,\n \"labels\": [\"\"]\n}];\nreturn msg;\n","outputs":1,"noerr":0,"x":235,"y":291,"wires":[["f21c8a97.fb6a98"]]},{"id":"81639fe0.2dd9f","type":"join","z":"b13d46a7.b0ff78","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":560,"y":190,"wires":[["903031fd.52e62"]]},{"id":"a9e9a2a2.000ee","type":"ui_group","z":"","name":"Chart","tab":"b37370af.e3696","order":2,"disp":true,"width":"6","collapse":false},{"id":"aae264f0.90e1d8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"iot_msgs","tz":"GMT-4:00"},{"id":"78d8a860.7260b8","type":"ui_group","z":"","name":"Selection","tab":"b37370af.e3696","order":1,"disp":true,"width":"6","collapse":false},{"id":"b37370af.e3696","type":"ui_tab","z":"","name":"Chart Review","icon":"dashboard","order":9}]

Thanks again!

2 Likes