Timeline Plot - to record events on a timeline

Continuing the discussion from :rocket: [FlexDash] alpha release - a dashboard for Node-RED:

@tve Is there an updated version of this ? i am unable to find a demo/example for this. i have moved most of my current dashboard to flexdash and now waiting for this widget to completely migrate. please help.

I want to achieve something like this.

1 Like

I'm not sure I understand what you're exactly looking for, but the TimelinePlot does output click events so you can display more detailed info, for example in a pop-up grid.

Sorry for not being clear.
I have a database of a machine with timestamp and status as two columns. status being boolean. i want the timeplot to show a single horizontal bar with chronological order of when the machine was running or stopped. (as green and red respectively, i am able to get the same with state-trail in NR-Dashboard.)
I am sure i am doing a wrong syntax, but after several tries, unable to get the same.

This is an inject node with the data as provided to the state-trail widget, i need to convert this to a syntax as required by timeline-plot. where i am stuck.

[{"id":"1a3f0d4bc79d1345","type":"inject","z":"bfa35172d1c05665","name":"Data","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"state\":\"TRUE\",\"timestamp\":1674278640000},{\"state\":\"TRUE\",\"timestamp\":1674278580000},{\"state\":\"TRUE\",\"timestamp\":1674278520000},{\"state\":\"TRUE\",\"timestamp\":1674278460000},{\"state\":\"TRUE\",\"timestamp\":1674278400000},{\"state\":\"TRUE\",\"timestamp\":1674278340000},{\"state\":\"TRUE\",\"timestamp\":1674278280000},{\"state\":\"TRUE\",\"timestamp\":1674278220000},{\"state\":\"TRUE\",\"timestamp\":1674278160000},{\"state\":\"TRUE\",\"timestamp\":1674278100000},{\"state\":\"TRUE\",\"timestamp\":1674278040000},{\"state\":\"TRUE\",\"timestamp\":1674277980000},{\"state\":\"FALSE\",\"timestamp\":1674277920000},{\"state\":\"FALSE\",\"timestamp\":1674277860000},{\"state\":\"FALSE\",\"timestamp\":1674277800000},{\"state\":\"FALSE\",\"timestamp\":1674277740000},{\"state\":\"FALSE\",\"timestamp\":1674277680000},{\"state\":\"FALSE\",\"timestamp\":1674277620000},{\"state\":\"FALSE\",\"timestamp\":1674277560000},{\"state\":\"FALSE\",\"timestamp\":1674277500000},{\"state\":\"TRUE\",\"timestamp\":1674277440000},{\"state\":\"TRUE\",\"timestamp\":1674277380000},{\"state\":\"TRUE\",\"timestamp\":1674277320000},{\"state\":\"TRUE\",\"timestamp\":1674277260000},{\"state\":\"TRUE\",\"timestamp\":1674277200000},{\"state\":\"TRUE\",\"timestamp\":1674277140000},{\"state\":\"TRUE\",\"timestamp\":1674277080000},{\"state\":\"TRUE\",\"timestamp\":1674277020000},{\"state\":\"TRUE\",\"timestamp\":1674276960000},{\"state\":\"TRUE\",\"timestamp\":1674276900000},{\"state\":\"TRUE\",\"timestamp\":1674276840000},{\"state\":\"FALSE\",\"timestamp\":1674276780000},{\"state\":\"FALSE\",\"timestamp\":1674276720000},{\"state\":\"FALSE\",\"timestamp\":1674276660000},{\"state\":\"FALSE\",\"timestamp\":1674276600000},{\"state\":\"FALSE\",\"timestamp\":1674276540000},{\"state\":\"TRUE\",\"timestamp\":1674276480000},{\"state\":\"TRUE\",\"timestamp\":1674276420000},{\"state\":\"TRUE\",\"timestamp\":1674276360000},{\"state\":\"TRUE\",\"timestamp\":1674276300000},{\"state\":\"TRUE\",\"timestamp\":1674276240000},{\"state\":\"TRUE\",\"timestamp\":1674276180000},{\"state\":\"TRUE\",\"timestamp\":1674276120000},{\"state\":\"TRUE\",\"timestamp\":1674276060000},{\"state\":\"TRUE\",\"timestamp\":1674276000000},{\"state\":\"TRUE\",\"timestamp\":1674275940000},{\"state\":\"TRUE\",\"timestamp\":1674275880000},{\"state\":\"TRUE\",\"timestamp\":1674275820000},{\"state\":\"TRUE\",\"timestamp\":1674275760000},{\"state\":\"FALSE\",\"timestamp\":1674275700000},{\"state\":\"FALSE\",\"timestamp\":1674275640000},{\"state\":\"FALSE\",\"timestamp\":1674275580000},{\"state\":\"FALSE\",\"timestamp\":1674275520000},{\"state\":\"TRUE\",\"timestamp\":1674275460000},{\"state\":\"TRUE\",\"timestamp\":1674275400000},{\"state\":\"TRUE\",\"timestamp\":1674275340000},{\"state\":\"TRUE\",\"timestamp\":1674275280000},{\"state\":\"TRUE\",\"timestamp\":1674275220000},{\"state\":\"TRUE\",\"timestamp\":1674275160000},{\"state\":\"TRUE\",\"timestamp\":1674275100000},{\"state\":\"TRUE\",\"timestamp\":1674275040000},{\"state\":\"TRUE\",\"timestamp\":1674274980000},{\"state\":\"TRUE\",\"timestamp\":1674274920000},{\"state\":\"TRUE\",\"timestamp\":1674274860000},{\"state\":\"TRUE\",\"timestamp\":1674274800000},{\"state\":\"TRUE\",\"timestamp\":1674274740000},{\"state\":\"TRUE\",\"timestamp\":1674274680000},{\"state\":\"TRUE\",\"timestamp\":1674274620000},{\"state\":\"TRUE\",\"timestamp\":1674274560000},{\"state\":\"TRUE\",\"timestamp\":1674274500000},{\"state\":\"TRUE\",\"timestamp\":1674274440000},{\"state\":\"TRUE\",\"timestamp\":1674274380000},{\"state\":\"TRUE\",\"timestamp\":1674274320000},{\"state\":\"TRUE\",\"timestamp\":1674274260000},{\"state\":\"TRUE\",\"timestamp\":1674274200000},{\"state\":\"TRUE\",\"timestamp\":1674274140000},{\"state\":\"TRUE\",\"timestamp\":1674274080000},{\"state\":\"TRUE\",\"timestamp\":1674274020000},{\"state\":\"TRUE\",\"timestamp\":1674273960000},{\"state\":\"TRUE\",\"timestamp\":1674273900000},{\"state\":\"TRUE\",\"timestamp\":1674273840000},{\"state\":\"TRUE\",\"timestamp\":1674273780000},{\"state\":\"TRUE\",\"timestamp\":1674273720000},{\"state\":\"TRUE\",\"timestamp\":1674273660000},{\"state\":\"TRUE\",\"timestamp\":1674273600000},{\"state\":\"TRUE\",\"timestamp\":1674273540000},{\"state\":\"TRUE\",\"timestamp\":1674273480000},{\"state\":\"TRUE\",\"timestamp\":1674273420000},{\"state\":\"TRUE\",\"timestamp\":1674273360000},{\"state\":\"TRUE\",\"timestamp\":1674273300000},{\"state\":\"TRUE\",\"timestamp\":1674273240000},{\"state\":\"TRUE\",\"timestamp\":1674273180000},{\"state\":\"TRUE\",\"timestamp\":1674273120000},{\"state\":\"TRUE\",\"timestamp\":1674273060000},{\"state\":\"TRUE\",\"timestamp\":1674273000000},{\"state\":\"TRUE\",\"timestamp\":1674272940000},{\"state\":\"TRUE\",\"timestamp\":1674272880000},{\"state\":\"TRUE\",\"timestamp\":1674272820000},{\"state\":\"TRUE\",\"timestamp\":1674272760000},{\"state\":\"TRUE\",\"timestamp\":1674272700000},{\"state\":\"TRUE\",\"timestamp\":1674272640000},{\"state\":\"TRUE\",\"timestamp\":1674272580000},{\"state\":\"TRUE\",\"timestamp\":1674272520000},{\"state\":\"TRUE\",\"timestamp\":1674272460000},{\"state\":\"TRUE\",\"timestamp\":1674272400000},{\"state\":\"TRUE\",\"timestamp\":1674272340000},{\"state\":\"TRUE\",\"timestamp\":1674272280000},{\"state\":\"TRUE\",\"timestamp\":1674272220000},{\"state\":\"TRUE\",\"timestamp\":1674272160000},{\"state\":\"TRUE\",\"timestamp\":1674272100000},{\"state\":\"TRUE\",\"timestamp\":1674272040000},{\"state\":\"TRUE\",\"timestamp\":1674271980000},{\"state\":\"TRUE\",\"timestamp\":1674271920000},{\"state\":\"TRUE\",\"timestamp\":1674271860000},{\"state\":\"TRUE\",\"timestamp\":1674271800000},{\"state\":\"TRUE\",\"timestamp\":1674271740000},{\"state\":\"TRUE\",\"timestamp\":1674271680000},{\"state\":\"TRUE\",\"timestamp\":1674271620000},{\"state\":\"TRUE\",\"timestamp\":1674271560000},{\"state\":\"TRUE\",\"timestamp\":1674271500000},{\"state\":\"TRUE\",\"timestamp\":1674271440000},{\"state\":\"TRUE\",\"timestamp\":1674271380000},{\"state\":\"TRUE\",\"timestamp\":1674271320000},{\"state\":\"TRUE\",\"timestamp\":1674271260000},{\"state\":\"TRUE\",\"timestamp\":1674271200000},{\"state\":\"TRUE\",\"timestamp\":1674271140000},{\"state\":\"TRUE\",\"timestamp\":1674271080000},{\"state\":\"TRUE\",\"timestamp\":1674271020000},{\"state\":\"TRUE\",\"timestamp\":1674270960000},{\"state\":\"TRUE\",\"timestamp\":1674270900000},{\"state\":\"TRUE\",\"timestamp\":1674270840000},{\"state\":\"TRUE\",\"timestamp\":1674270780000},{\"state\":\"TRUE\",\"timestamp\":1674270720000},{\"state\":\"TRUE\",\"timestamp\":1674270660000},{\"state\":\"TRUE\",\"timestamp\":1674270600000},{\"state\":\"TRUE\",\"timestamp\":1674270540000},{\"state\":\"TRUE\",\"timestamp\":1674270480000},{\"state\":\"TRUE\",\"timestamp\":1674270420000},{\"state\":\"TRUE\",\"timestamp\":1674270360000},{\"state\":\"TRUE\",\"timestamp\":1674270300000},{\"state\":\"TRUE\",\"timestamp\":1674270240000},{\"state\":\"TRUE\",\"timestamp\":1674270180000},{\"state\":\"TRUE\",\"timestamp\":1674270120000},{\"state\":\"TRUE\",\"timestamp\":1674270060000},{\"state\":\"TRUE\",\"timestamp\":1674270000000},{\"state\":\"TRUE\",\"timestamp\":1674269940000},{\"state\":\"TRUE\",\"timestamp\":1674269880000},{\"state\":\"TRUE\",\"timestamp\":1674269820000},{\"state\":\"TRUE\",\"timestamp\":1674269760000},{\"state\":\"TRUE\",\"timestamp\":1674269700000},{\"state\":\"TRUE\",\"timestamp\":1674269640000},{\"state\":\"TRUE\",\"timestamp\":1674269580000},{\"state\":\"TRUE\",\"timestamp\":1674269520000},{\"state\":\"TRUE\",\"timestamp\":1674269460000},{\"state\":\"TRUE\",\"timestamp\":1674269400000},{\"state\":\"TRUE\",\"timestamp\":1674269340000},{\"state\":\"TRUE\",\"timestamp\":1674269280000},{\"state\":\"TRUE\",\"timestamp\":1674269220000},{\"state\":\"TRUE\",\"timestamp\":1674269160000},{\"state\":\"TRUE\",\"timestamp\":1674269100000},{\"state\":\"TRUE\",\"timestamp\":1674269040000},{\"state\":\"TRUE\",\"timestamp\":1674268980000},{\"state\":\"TRUE\",\"timestamp\":1674268920000},{\"state\":\"TRUE\",\"timestamp\":1674268860000},{\"state\":\"TRUE\",\"timestamp\":1674268800000},{\"state\":\"TRUE\",\"timestamp\":1674268740000},{\"state\":\"TRUE\",\"timestamp\":1674268680000},{\"state\":\"TRUE\",\"timestamp\":1674268620000},{\"state\":\"TRUE\",\"timestamp\":1674268560000},{\"state\":\"TRUE\",\"timestamp\":1674268500000},{\"state\":\"TRUE\",\"timestamp\":1674268440000},{\"state\":\"TRUE\",\"timestamp\":1674268380000},{\"state\":\"TRUE\",\"timestamp\":1674268320000},{\"state\":\"TRUE\",\"timestamp\":1674268260000},{\"state\":\"FALSE\",\"timestamp\":1674268200000},{\"state\":\"FALSE\",\"timestamp\":1674268140000},{\"state\":\"FALSE\",\"timestamp\":1674268080000},{\"state\":\"FALSE\",\"timestamp\":1674268020000},{\"state\":\"FALSE\",\"timestamp\":1674267960000},{\"state\":\"FALSE\",\"timestamp\":1674267900000},{\"state\":\"FALSE\",\"timestamp\":1674267840000},{\"state\":\"FALSE\",\"timestamp\":1674267780000},{\"state\":\"FALSE\",\"timestamp\":1674267720000},{\"state\":\"FALSE\",\"timestamp\":1674267660000},{\"state\":\"FALSE\",\"timestamp\":1674267600000},{\"state\":\"FALSE\",\"timestamp\":1674267540000},{\"state\":\"TRUE\",\"timestamp\":1674267480000},{\"state\":\"TRUE\",\"timestamp\":1674267420000},{\"state\":\"TRUE\",\"timestamp\":1674267360000},{\"state\":\"TRUE\",\"timestamp\":1674267300000},{\"state\":\"TRUE\",\"timestamp\":1674267240000},{\"state\":\"TRUE\",\"timestamp\":1674267180000},{\"state\":\"TRUE\",\"timestamp\":1674267120000},{\"state\":\"TRUE\",\"timestamp\":1674267060000},{\"state\":\"TRUE\",\"timestamp\":1674267000000},{\"state\":\"TRUE\",\"timestamp\":1674266940000},{\"state\":\"TRUE\",\"timestamp\":1674266880000},{\"state\":\"TRUE\",\"timestamp\":1674266820000},{\"state\":\"TRUE\",\"timestamp\":1674266760000},{\"state\":\"TRUE\",\"timestamp\":1674266700000},{\"state\":\"TRUE\",\"timestamp\":1674266640000},{\"state\":\"TRUE\",\"timestamp\":1674266580000},{\"state\":\"TRUE\",\"timestamp\":1674266520000},{\"state\":\"TRUE\",\"timestamp\":1674266460000},{\"state\":\"TRUE\",\"timestamp\":1674266400000},{\"state\":\"TRUE\",\"timestamp\":1674266340000},{\"state\":\"TRUE\",\"timestamp\":1674266280000},{\"state\":\"TRUE\",\"timestamp\":1674266220000},{\"state\":\"TRUE\",\"timestamp\":1674266160000},{\"state\":\"FALSE\",\"timestamp\":1674266100000},{\"state\":\"FALSE\",\"timestamp\":1674266040000},{\"state\":\"FALSE\",\"timestamp\":1674265980000},{\"state\":\"FALSE\",\"timestamp\":1674265920000},{\"state\":\"FALSE\",\"timestamp\":1674265860000},{\"state\":\"FALSE\",\"timestamp\":1674265800000},{\"state\":\"FALSE\",\"timestamp\":1674265740000},{\"state\":\"FALSE\",\"timestamp\":1674265680000},{\"state\":\"FALSE\",\"timestamp\":1674265620000},{\"state\":\"FALSE\",\"timestamp\":1674265560000},{\"state\":\"FALSE\",\"timestamp\":1674265500000},{\"state\":\"FALSE\",\"timestamp\":1674265440000},{\"state\":\"FALSE\",\"timestamp\":1674265380000},{\"state\":\"FALSE\",\"timestamp\":1674265320000},{\"state\":\"FALSE\",\"timestamp\":1674265260000},{\"state\":\"TRUE\",\"timestamp\":1674265200000},{\"state\":\"FALSE\",\"timestamp\":1674265140000},{\"state\":\"FALSE\",\"timestamp\":1674265080000},{\"state\":\"FALSE\",\"timestamp\":1674265020000},{\"state\":\"FALSE\",\"timestamp\":1674264960000},{\"state\":\"TRUE\",\"timestamp\":1674264900000},{\"state\":\"TRUE\",\"timestamp\":1674264840000},{\"state\":\"TRUE\",\"timestamp\":1674264780000},{\"state\":\"TRUE\",\"timestamp\":1674264720000},{\"state\":\"TRUE\",\"timestamp\":1674264660000},{\"state\":\"TRUE\",\"timestamp\":1674264600000},{\"state\":\"TRUE\",\"timestamp\":1674264540000},{\"state\":\"TRUE\",\"timestamp\":1674264480000},{\"state\":\"TRUE\",\"timestamp\":1674264420000},{\"state\":\"TRUE\",\"timestamp\":1674264360000},{\"state\":\"TRUE\",\"timestamp\":1674264300000},{\"state\":\"TRUE\",\"timestamp\":1674264240000},{\"state\":\"TRUE\",\"timestamp\":1674264180000},{\"state\":\"TRUE\",\"timestamp\":1674264120000},{\"state\":\"TRUE\",\"timestamp\":1674264060000},{\"state\":\"TRUE\",\"timestamp\":1674264000000},{\"state\":\"TRUE\",\"timestamp\":1674263940000},{\"state\":\"TRUE\",\"timestamp\":1674263880000},{\"state\":\"TRUE\",\"timestamp\":1674263820000},{\"state\":\"TRUE\",\"timestamp\":1674263760000},{\"state\":\"TRUE\",\"timestamp\":1674263700000},{\"state\":\"FALSE\",\"timestamp\":1674263640000},{\"state\":\"FALSE\",\"timestamp\":1674263580000},{\"state\":\"FALSE\",\"timestamp\":1674263520000},{\"state\":\"FALSE\",\"timestamp\":1674263460000},{\"state\":\"FALSE\",\"timestamp\":1674263400000},{\"state\":\"FALSE\",\"timestamp\":1674263340000},{\"state\":\"FALSE\",\"timestamp\":1674263280000},{\"state\":\"FALSE\",\"timestamp\":1674263220000},{\"state\":\"FALSE\",\"timestamp\":1674263160000},{\"state\":\"FALSE\",\"timestamp\":1674263100000},{\"state\":\"FALSE\",\"timestamp\":1674263040000},{\"state\":\"FALSE\",\"timestamp\":1674262980000},{\"state\":\"FALSE\",\"timestamp\":1674262920000},{\"state\":\"FALSE\",\"timestamp\":1674262860000},{\"state\":\"FALSE\",\"timestamp\":1674262800000},{\"state\":\"FALSE\",\"timestamp\":1674262740000},{\"state\":\"FALSE\",\"timestamp\":1674262680000},{\"state\":\"FALSE\",\"timestamp\":1674262620000},{\"state\":\"FALSE\",\"timestamp\":1674262560000},{\"state\":\"FALSE\",\"timestamp\":1674262500000},{\"state\":\"FALSE\",\"timestamp\":1674262440000},{\"state\":\"FALSE\",\"timestamp\":1674262380000},{\"state\":\"FALSE\",\"timestamp\":1674262320000},{\"state\":\"FALSE\",\"timestamp\":1674262260000},{\"state\":\"FALSE\",\"timestamp\":1674262200000},{\"state\":\"FALSE\",\"timestamp\":1674262140000},{\"state\":\"FALSE\",\"timestamp\":1674262080000},{\"state\":\"FALSE\",\"timestamp\":1674262020000},{\"state\":\"FALSE\",\"timestamp\":1674261960000},{\"state\":\"FALSE\",\"timestamp\":1674261900000},{\"state\":\"FALSE\",\"timestamp\":1674261840000},{\"state\":\"FALSE\",\"timestamp\":1674261780000},{\"state\":\"FALSE\",\"timestamp\":1674261720000},{\"state\":\"FALSE\",\"timestamp\":1674261660000},{\"state\":\"FALSE\",\"timestamp\":1674261600000},{\"state\":\"FALSE\",\"timestamp\":1674261540000},{\"state\":\"FALSE\",\"timestamp\":1674261480000},{\"state\":\"FALSE\",\"timestamp\":1674261420000},{\"state\":\"FALSE\",\"timestamp\":1674261360000},{\"state\":\"FALSE\",\"timestamp\":1674261300000},{\"state\":\"FALSE\",\"timestamp\":1674261240000},{\"state\":\"FALSE\",\"timestamp\":1674261180000},{\"state\":\"FALSE\",\"timestamp\":1674261120000},{\"state\":\"FALSE\",\"timestamp\":1674261060000},{\"state\":\"TRUE\",\"timestamp\":1674261000000},{\"state\":\"TRUE\",\"timestamp\":1674260940000},{\"state\":\"TRUE\",\"timestamp\":1674260880000},{\"state\":\"TRUE\",\"timestamp\":1674260820000},{\"state\":\"TRUE\",\"timestamp\":1674260760000},{\"state\":\"TRUE\",\"timestamp\":1674260700000},{\"state\":\"TRUE\",\"timestamp\":1674260640000},{\"state\":\"TRUE\",\"timestamp\":1674260580000},{\"state\":\"TRUE\",\"timestamp\":1674260520000},{\"state\":\"TRUE\",\"timestamp\":1674260460000},{\"state\":\"TRUE\",\"timestamp\":1674260400000},{\"state\":\"TRUE\",\"timestamp\":1674260340000},{\"state\":\"TRUE\",\"timestamp\":1674260280000},{\"state\":\"TRUE\",\"timestamp\":1674260220000},{\"state\":\"TRUE\",\"timestamp\":1674260160000},{\"state\":\"TRUE\",\"timestamp\":1674260100000},{\"state\":\"TRUE\",\"timestamp\":1674260040000},{\"state\":\"TRUE\",\"timestamp\":1674259980000},{\"state\":\"TRUE\",\"timestamp\":1674259920000},{\"state\":\"TRUE\",\"timestamp\":1674259860000},{\"state\":\"TRUE\",\"timestamp\":1674259800000},{\"state\":\"TRUE\",\"timestamp\":1674259740000},{\"state\":\"TRUE\",\"timestamp\":1674259680000},{\"state\":\"TRUE\",\"timestamp\":1674259620000},{\"state\":\"TRUE\",\"timestamp\":1674259560000},{\"state\":\"TRUE\",\"timestamp\":1674259500000},{\"state\":\"TRUE\",\"timestamp\":1674259440000},{\"state\":\"FALSE\",\"timestamp\":1674259380000},{\"state\":\"TRUE\",\"timestamp\":1674259320000},{\"state\":\"TRUE\",\"timestamp\":1674259260000},{\"state\":\"TRUE\",\"timestamp\":1674259200000},{\"state\":\"TRUE\",\"timestamp\":1674259140000},{\"state\":\"TRUE\",\"timestamp\":1674259080000},{\"state\":\"TRUE\",\"timestamp\":1674259020000},{\"state\":\"TRUE\",\"timestamp\":1674258960000},{\"state\":\"TRUE\",\"timestamp\":1674258900000},{\"state\":\"FALSE\",\"timestamp\":1674258840000},{\"state\":\"FALSE\",\"timestamp\":1674258780000},{\"state\":\"FALSE\",\"timestamp\":1674258720000},{\"state\":\"FALSE\",\"timestamp\":1674258660000},{\"state\":\"TRUE\",\"timestamp\":1674258600000},{\"state\":\"TRUE\",\"timestamp\":1674258540000},{\"state\":\"TRUE\",\"timestamp\":1674258480000},{\"state\":\"TRUE\",\"timestamp\":1674258420000},{\"state\":\"TRUE\",\"timestamp\":1674258360000},{\"state\":\"TRUE\",\"timestamp\":1674258300000},{\"state\":\"TRUE\",\"timestamp\":1674258240000},{\"state\":\"TRUE\",\"timestamp\":1674258180000},{\"state\":\"TRUE\",\"timestamp\":1674258120000},{\"state\":\"TRUE\",\"timestamp\":1674258060000},{\"state\":\"TRUE\",\"timestamp\":1674258000000},{\"state\":\"TRUE\",\"timestamp\":1674257940000},{\"state\":\"TRUE\",\"timestamp\":1674257880000},{\"state\":\"TRUE\",\"timestamp\":1674257820000},{\"state\":\"TRUE\",\"timestamp\":1674257760000},{\"state\":\"TRUE\",\"timestamp\":1674257700000},{\"state\":\"TRUE\",\"timestamp\":1674257640000},{\"state\":\"TRUE\",\"timestamp\":1674257580000},{\"state\":\"TRUE\",\"timestamp\":1674257520000},{\"state\":\"TRUE\",\"timestamp\":1674257460000},{\"state\":\"TRUE\",\"timestamp\":1674257400000},{\"state\":\"TRUE\",\"timestamp\":1674257340000},{\"state\":\"TRUE\",\"timestamp\":1674257280000},{\"state\":\"TRUE\",\"timestamp\":1674257220000},{\"state\":\"TRUE\",\"timestamp\":1674257160000},{\"state\":\"TRUE\",\"timestamp\":1674257100000},{\"state\":\"TRUE\",\"timestamp\":1674257040000},{\"state\":\"TRUE\",\"timestamp\":1674256980000},{\"state\":\"TRUE\",\"timestamp\":1674256920000},{\"state\":\"TRUE\",\"timestamp\":1674256860000},{\"state\":\"TRUE\",\"timestamp\":1674256800000},{\"state\":\"TRUE\",\"timestamp\":1674256740000},{\"state\":\"TRUE\",\"timestamp\":1674256680000},{\"state\":\"TRUE\",\"timestamp\":1674256620000},{\"state\":\"TRUE\",\"timestamp\":1674256560000},{\"state\":\"TRUE\",\"timestamp\":1674256500000},{\"state\":\"TRUE\",\"timestamp\":1674256440000},{\"state\":\"TRUE\",\"timestamp\":1674256380000},{\"state\":\"TRUE\",\"timestamp\":1674256320000},{\"state\":\"TRUE\",\"timestamp\":1674256260000},{\"state\":\"TRUE\",\"timestamp\":1674256200000},{\"state\":\"TRUE\",\"timestamp\":1674256140000},{\"state\":\"TRUE\",\"timestamp\":1674256080000},{\"state\":\"TRUE\",\"timestamp\":1674256020000},{\"state\":\"TRUE\",\"timestamp\":1674255960000},{\"state\":\"TRUE\",\"timestamp\":1674255900000},{\"state\":\"TRUE\",\"timestamp\":1674255840000},{\"state\":\"TRUE\",\"timestamp\":1674255780000},{\"state\":\"TRUE\",\"timestamp\":1674255720000},{\"state\":\"TRUE\",\"timestamp\":1674255660000},{\"state\":\"TRUE\",\"timestamp\":1674255600000},{\"state\":\"TRUE\",\"timestamp\":1674255540000},{\"state\":\"TRUE\",\"timestamp\":1674255480000},{\"state\":\"TRUE\",\"timestamp\":1674255420000},{\"state\":\"TRUE\",\"timestamp\":1674255360000},{\"state\":\"TRUE\",\"timestamp\":1674255300000},{\"state\":\"TRUE\",\"timestamp\":1674255240000},{\"state\":\"TRUE\",\"timestamp\":1674255180000},{\"state\":\"TRUE\",\"timestamp\":1674255120000},{\"state\":\"TRUE\",\"timestamp\":1674255060000},{\"state\":\"TRUE\",\"timestamp\":1674255000000},{\"state\":\"TRUE\",\"timestamp\":1674254940000},{\"state\":\"TRUE\",\"timestamp\":1674254880000},{\"state\":\"TRUE\",\"timestamp\":1674254820000},{\"state\":\"TRUE\",\"timestamp\":1674254760000},{\"state\":\"TRUE\",\"timestamp\":1674254700000},{\"state\":\"TRUE\",\"timestamp\":1674254640000},{\"state\":\"TRUE\",\"timestamp\":1674254580000},{\"state\":\"TRUE\",\"timestamp\":1674254520000},{\"state\":\"TRUE\",\"timestamp\":1674254460000},{\"state\":\"TRUE\",\"timestamp\":1674254400000},{\"state\":\"TRUE\",\"timestamp\":1674254340000},{\"state\":\"TRUE\",\"timestamp\":1674254280000},{\"state\":\"TRUE\",\"timestamp\":1674254220000},{\"state\":\"TRUE\",\"timestamp\":1674254160000},{\"state\":\"TRUE\",\"timestamp\":1674254100000},{\"state\":\"TRUE\",\"timestamp\":1674254040000},{\"state\":\"TRUE\",\"timestamp\":1674253980000},{\"state\":\"TRUE\",\"timestamp\":1674253920000},{\"state\":\"TRUE\",\"timestamp\":1674253860000},{\"state\":\"TRUE\",\"timestamp\":1674253800000},{\"state\":\"TRUE\",\"timestamp\":1674253740000},{\"state\":\"TRUE\",\"timestamp\":1674253680000},{\"state\":\"TRUE\",\"timestamp\":1674253620000},{\"state\":\"TRUE\",\"timestamp\":1674253560000},{\"state\":\"TRUE\",\"timestamp\":1674253500000},{\"state\":\"TRUE\",\"timestamp\":1674253440000},{\"state\":\"TRUE\",\"timestamp\":1674253380000},{\"state\":\"TRUE\",\"timestamp\":1674253320000},{\"state\":\"TRUE\",\"timestamp\":1674253260000},{\"state\":\"TRUE\",\"timestamp\":1674253200000},{\"state\":\"TRUE\",\"timestamp\":1674253140000},{\"state\":\"TRUE\",\"timestamp\":1674253080000},{\"state\":\"FALSE\",\"timestamp\":1674253020000},{\"state\":\"FALSE\",\"timestamp\":1674252960000},{\"state\":\"TRUE\",\"timestamp\":1674252900000},{\"state\":\"TRUE\",\"timestamp\":1674252840000},{\"state\":\"FALSE\",\"timestamp\":1674252780000},{\"state\":\"FALSE\",\"timestamp\":1674252720000},{\"state\":\"FALSE\",\"timestamp\":1674252660000},{\"state\":\"TRUE\",\"timestamp\":1674252600000},{\"state\":\"FALSE\",\"timestamp\":1674252540000},{\"state\":\"FALSE\",\"timestamp\":1674252480000},{\"state\":\"TRUE\",\"timestamp\":1674252420000},{\"state\":\"TRUE\",\"timestamp\":1674252360000},{\"state\":\"TRUE\",\"timestamp\":1674252300000},{\"state\":\"TRUE\",\"timestamp\":1674252240000},{\"state\":\"TRUE\",\"timestamp\":1674252180000},{\"state\":\"TRUE\",\"timestamp\":1674252120000},{\"state\":\"TRUE\",\"timestamp\":1674252060000},{\"state\":\"TRUE\",\"timestamp\":1674252000000},{\"state\":\"TRUE\",\"timestamp\":1674251940000},{\"state\":\"TRUE\",\"timestamp\":1674251880000},{\"state\":\"FALSE\",\"timestamp\":1674251820000},{\"state\":\"FALSE\",\"timestamp\":1674251760000},{\"state\":\"FALSE\",\"timestamp\":1674251700000},{\"state\":\"FALSE\",\"timestamp\":1674251640000},{\"state\":\"FALSE\",\"timestamp\":1674251580000},{\"state\":\"FALSE\",\"timestamp\":1674251520000},{\"state\":\"FALSE\",\"timestamp\":1674251460000},{\"state\":\"FALSE\",\"timestamp\":1674251400000},{\"state\":\"FALSE\",\"timestamp\":1674251340000},{\"state\":\"FALSE\",\"timestamp\":1674251280000},{\"state\":\"FALSE\",\"timestamp\":1674251220000},{\"state\":\"FALSE\",\"timestamp\":1674251160000},{\"state\":\"FALSE\",\"timestamp\":1674251100000},{\"state\":\"FALSE\",\"timestamp\":1674251040000},{\"state\":\"FALSE\",\"timestamp\":1674250980000},{\"state\":\"FALSE\",\"timestamp\":1674250920000},{\"state\":\"FALSE\",\"timestamp\":1674250860000},{\"state\":\"FALSE\",\"timestamp\":1674250800000},{\"state\":\"FALSE\",\"timestamp\":1674250740000},{\"state\":\"FALSE\",\"timestamp\":1674250680000},{\"state\":\"FALSE\",\"timestamp\":1674250620000},{\"state\":\"FALSE\",\"timestamp\":1674250560000},{\"state\":\"FALSE\",\"timestamp\":1674250500000},{\"state\":\"FALSE\",\"timestamp\":1674250440000},{\"state\":\"FALSE\",\"timestamp\":1674250380000},{\"state\":\"FALSE\",\"timestamp\":1674250320000},{\"state\":\"FALSE\",\"timestamp\":1674250260000},{\"state\":\"FALSE\",\"timestamp\":1674250200000},{\"state\":\"FALSE\",\"timestamp\":1674250140000},{\"state\":\"FALSE\",\"timestamp\":1674250080000},{\"state\":\"FALSE\",\"timestamp\":1674250020000},{\"state\":\"FALSE\",\"timestamp\":1674249960000},{\"state\":\"FALSE\",\"timestamp\":1674249900000}]","payloadType":"json","x":900,"y":1900,"wires":[[]]}]

what i tried, and what i am getting.

[{"id":"27ec834de567b66c","type":"inject","z":"f6bf1c3dee4d1f8a","name":"","props":[{"p":"payload1","v":"","vt":"date"},{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"stat\":100,\"timestamp\":1674203340000},{\"stat\":100,\"timestamp\":1674203280000},{\"stat\":200,\"timestamp\":1674203220000},{\"stat\":200,\"timestamp\":1674203160000},{\"stat\":100,\"timestamp\":1674203100000},{\"stat\":100,\"timestamp\":1674203040000},{\"stat\":100,\"timestamp\":1674202980000},{\"stat\":100,\"timestamp\":1674202920000},{\"stat\":100,\"timestamp\":1674202860000},{\"stat\":100,\"timestamp\":1674202800000},{\"stat\":100,\"timestamp\":1674202740000},{\"stat\":100,\"timestamp\":1674202680000},{\"stat\":100,\"timestamp\":1674202620000},{\"stat\":100,\"timestamp\":1674202560000},{\"stat\":100,\"timestamp\":1674202500000},{\"stat\":100,\"timestamp\":1674202440000},{\"stat\":200,\"timestamp\":1674202380000},{\"stat\":200,\"timestamp\":1674202320000},{\"stat\":200,\"timestamp\":1674202260000},{\"stat\":200,\"timestamp\":1674202200000}]","payloadType":"json","x":290,"y":380,"wires":[["992e13f84933dde6"]]},{"id":"992e13f84933dde6","type":"change","z":"f6bf1c3dee4d1f8a","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$.payload.[$.*]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":460,"y":380,"wires":[["faac50db80c467d0","078aa668f5bf1983"]]},{"id":"faac50db80c467d0","type":"debug","z":"f6bf1c3dee4d1f8a","name":"debug 130","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":670,"y":380,"wires":[]},{"id":"078aa668f5bf1983","type":"fd-timeline-plot","z":"f6bf1c3dee4d1f8a","fd_container":"9582b98092d3d744","fd_cols":"12","fd_rows":"10","fd_array":false,"fd_array_max":10,"fd_output_topic":"","fd_loopback":false,"name":"","title":"Timeline Plot","popup_info":"","options":{},"data":null,"colors":null,"labels":null,"gradient":null,"show_values":true,"click":true,"x":670,"y":420,"wires":[[]]},{"id":"9582b98092d3d744","type":"flexdash container","name":"grid6","kind":"StdGrid","fd_children":",d2dbe97c44f6fb5a,078aa668f5bf1983","title":"","tab":"a712b31dfea280d2","min_cols":"1","max_cols":"20","parent":"","solid":false,"cols":"1","rows":"1"},{"id":"a712b31dfea280d2","type":"flexdash tab","name":"chart","icon":"mdi-chart-line","title":"","fd_children":",28d1859702cdf729,9582b98092d3d744","fd":"e8f5aea52ab49500"}]

I replaced boolean true or false with 100 and 200 since i was not able to get anything on timeline plot with true or false, as long as they are two different colors i am ok

EDIT - Progress

I manually fed the data and able to get nearly what i want it to look like, however need still support on 'transforming ' the data from mysql query to the syntax this requires.

image
first array as timeseries and second array as data.

Questions:
If i need to , how do i remove the vertical black lines ?
Click event not showing anything on debug node, i have made it true in the config
image
I can double click and zoom on the segment though.

1 Like

Thanks for posting the details! Here's what's happening:

  • the timeplot widget needs an X (time) series, and separate series for each of the bars. You noticed that in your edit.
  • the times need to be in sorted order, the sample you pasted was not, sorting it fixes the display
  • there's a bug where the output on click fails if the bars don't have labels, I need to fix that, oops!

Here's a little rework that fixes the issues using a 4-line function node:

const pl = msg.payload.sort((a,b) => a.timestamp - b.timestamp)
const times = pl.map(v => v.timestamp)
const values = pl.map(v => v.stat)
return { payload: [ times, values ] }
[{"id":"27ec834de567b66c","type":"inject","z":"42aa3359d7ac96f5","name":"","props":[{"p":"payload1","v":"","vt":"date"},{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"stat\":100,\"timestamp\":1674203340000},{\"stat\":100,\"timestamp\":1674203280000},{\"stat\":200,\"timestamp\":1674203220000},{\"stat\":200,\"timestamp\":1674203160000},{\"stat\":100,\"timestamp\":1674203100000},{\"stat\":100,\"timestamp\":1674203040000},{\"stat\":100,\"timestamp\":1674202980000},{\"stat\":100,\"timestamp\":1674202920000},{\"stat\":100,\"timestamp\":1674202860000},{\"stat\":100,\"timestamp\":1674202800000},{\"stat\":100,\"timestamp\":1674202740000},{\"stat\":100,\"timestamp\":1674202680000},{\"stat\":100,\"timestamp\":1674202620000},{\"stat\":100,\"timestamp\":1674202560000},{\"stat\":100,\"timestamp\":1674202500000},{\"stat\":100,\"timestamp\":1674202440000},{\"stat\":200,\"timestamp\":1674202380000},{\"stat\":200,\"timestamp\":1674202320000},{\"stat\":200,\"timestamp\":1674202260000},{\"stat\":200,\"timestamp\":1674202200000}]","payloadType":"json","x":90,"y":500,"wires":[["2e6adf17eb8275af"]]},{"id":"faac50db80c467d0","type":"debug","z":"42aa3359d7ac96f5","name":"debug 130","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":430,"y":540,"wires":[]},{"id":"078aa668f5bf1983","type":"fd-timeline-plot","z":"42aa3359d7ac96f5","fd_container":"a96ede31d15e8fcc","fd_cols":"6","fd_rows":"2","fd_array":false,"fd_array_max":10,"fd_output_topic":"","fd_loopback":false,"name":"","title":"Timeline Plot","popup_info":"","options":{},"data":null,"colors":null,"labels":["hello"],"gradient":null,"show_values":true,"click":true,"x":430,"y":500,"wires":[["faac50db80c467d0"]]},{"id":"2e6adf17eb8275af","type":"function","z":"42aa3359d7ac96f5","name":"prep payload","func":"\nconst pl = msg.payload.sort((a,b) => a.timestamp - b.timestamp)\nconst times = pl.map(v => v.timestamp)\nconst values = pl.map(v => v.stat)\nreturn { payload: [ times, values ] }","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":250,"y":500,"wires":[["078aa668f5bf1983"]]},{"id":"a96ede31d15e8fcc","type":"flexdash container","name":"Repro","title":"","kind":"StdGrid","fd_children":",7d8110bad209c9b4,e7c4f917522b9e07,73d471ead270d371,0ca10a099f0a6969,1d8ee88fedb20405,e0dc4b448dc085ca,78673e91a6b52f72,e9b320e81e2e1981,e7b8b8127072bebb,078aa668f5bf1983","tab":"1e908252f3517797","min_cols":"6","max_cols":"20","unicast":"ignore","parent":"","solid":false,"cols":"1","rows":"1"},{"id":"1e908252f3517797","type":"flexdash tab","name":"Repros","icon":"mdi-view-dashboard","title":"Repro","fd_children":",a96ede31d15e8fcc","fd":"e8f5aea52ab49500"}]


image

You can assign the colors you like to values, please read the help on how to do that. However, boolean values don't work, they have to be numbers.
I hope this gets you unstuck! Thanks for trying out FlexDash and reporting issues!!

1 Like

Success!

Minor issues:

  1. I can still see the black vertical lines
  2. the time data i get after clicking the bar is not converting back to correct time, (i use the same method else where and it is fine), you can notice that the tooltip on hover is showing correctly. but when i convert payload.time to human readable format, strange date/time is given.
  3. Upon clicking one segment, can i get the begining and ending of the time, it will be easier to construct a message that machine was down or up from and to a period.

image

time-trail

1 Like

For the example above, what actual output do you get from the payload.time?

image

image

image

This is the input to the moment node

1674246293.7726238

20-Jan-70, 14:34 this is the output from moment node

the input turns out correctly in a website converter as below

That appears to be any issue with the conversion process and not Flexdash.

Strange, I don't use the moment node but inputting 1674246293.7726238 into a change node (using the node-RED inbuilt moment library), I get;

output

Which I assume is correct (except timezone difference)

Try;

[{"id":"54c46ebe.3b623","type":"change","z":"1543d308b342690a","name":"Change node","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment()","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":710,"y":1895,"wires":[["2c896b1f.98a694"]]},{"id":"2c896b1f.98a694","type":"debug","z":"1543d308b342690a","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":880,"y":1895,"wires":[]},{"id":"7991fc04.3ff914","type":"inject","z":"1543d308b342690a","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"1674246293.7726238","payloadType":"num","x":510,"y":1895,"wires":[["54c46ebe.3b623"]]}]

For more examples about using the in-built moment library (including selecting the timezone), see this post that I wrote some time ago.

I did refer to the post before posting here. unfortunately the time is not displayed correctly even with your example. the whole timeline is 480 minutes in my example, but anywhere i click i am getting difference only in seconds and not in minutes or hours.

I am not sure, because the timestamp returned by flexdash is not correct, the tooltip however is showing correctly. you cannot see clearly in my GIF attachment above, but the entire width of the bar is spanning 8 hours. from 20th Jan 22:00 hrs to 21st Jan 06:00 Hrs Next day local time.

I am successfully using mysql query with unixtimestamp query and converting to readable Indian Standard Time format with contrib-moment , so the contrib node is just fine.

i am not sure where is the problem,

i will create a simple flow to get more sense of what happening.

1 Like

I think i got it

i multiplied the payload.time by 1000 and it is now showing approximately ok, it is off by some minutes, but i think multiplying by 1000 is not correct way, but I am getting almost right

i just compared my other flow where i use moment node and the input is always a 13 digit number, here it was less 10 digits+ few decimals,

Doesn't the moment node handle 10 digits (seconds precision)?
In my example above using a change node & the moment library, it worked just fine.
But yours gave this;

13 digits seems to work correctly. although last 3 digits are always 000 (since my timestamp do not change seconds, increment is only minutes ?)

Gaps (black bars) only show up if there is a gap in the data (null values).
I can look into the bars & timestamps if I have a sample flow to look into...

Here's an inject node with my data.
There are 480 points data each representing a minute for time from 20th Jan 2023 10:00 PM to 21st Jan 2023 05:59 AM local time, so i don't expect gaps in the data.

this is what i see in timestamp debug for first and last record.
image

image

the tooltip on the time line bar also shows correctly
image
image

the click output timestamp is not converting into same date time
when i multiply by 1000, it shows almost correct datetime off by a couple of minutes.
the raw click data when converted shows a date in 1970.

image

the same flow when i use for State-trail widget and i get a click output from that, i properly get date and time, similar flow, and also the widget gives two timestamps (one at the start of segment and one at the end of segment)

image

[{"id":"1817ad9ba1e05dc0","type":"inject","z":"f6bf1c3dee4d1f8a","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"timestamp\":1674260940,\"stat\":1},{\"timestamp\":1674260880,\"stat\":1},{\"timestamp\":1674260820,\"stat\":1},{\"timestamp\":1674260760,\"stat\":1},{\"timestamp\":1674260700,\"stat\":1},{\"timestamp\":1674260640,\"stat\":1},{\"timestamp\":1674260580,\"stat\":1},{\"timestamp\":1674260520,\"stat\":1},{\"timestamp\":1674260460,\"stat\":1},{\"timestamp\":1674260400,\"stat\":1},{\"timestamp\":1674260340,\"stat\":1},{\"timestamp\":1674260280,\"stat\":1},{\"timestamp\":1674260220,\"stat\":1},{\"timestamp\":1674260160,\"stat\":1},{\"timestamp\":1674260100,\"stat\":1},{\"timestamp\":1674260040,\"stat\":1},{\"timestamp\":1674259980,\"stat\":1},{\"timestamp\":1674259920,\"stat\":1},{\"timestamp\":1674259860,\"stat\":1},{\"timestamp\":1674259800,\"stat\":1},{\"timestamp\":1674259740,\"stat\":1},{\"timestamp\":1674259680,\"stat\":1},{\"timestamp\":1674259620,\"stat\":1},{\"timestamp\":1674259560,\"stat\":1},{\"timestamp\":1674259500,\"stat\":1},{\"timestamp\":1674259440,\"stat\":1},{\"timestamp\":1674259380,\"stat\":0},{\"timestamp\":1674259320,\"stat\":1},{\"timestamp\":1674259260,\"stat\":1},{\"timestamp\":1674259200,\"stat\":1},{\"timestamp\":1674259140,\"stat\":1},{\"timestamp\":1674259080,\"stat\":1},{\"timestamp\":1674259020,\"stat\":1},{\"timestamp\":1674258960,\"stat\":1},{\"timestamp\":1674258900,\"stat\":1},{\"timestamp\":1674258840,\"stat\":0},{\"timestamp\":1674258780,\"stat\":0},{\"timestamp\":1674258720,\"stat\":0},{\"timestamp\":1674258660,\"stat\":0},{\"timestamp\":1674258600,\"stat\":1},{\"timestamp\":1674258540,\"stat\":1},{\"timestamp\":1674258480,\"stat\":1},{\"timestamp\":1674258420,\"stat\":1},{\"timestamp\":1674258360,\"stat\":1},{\"timestamp\":1674258300,\"stat\":1},{\"timestamp\":1674258240,\"stat\":1},{\"timestamp\":1674258180,\"stat\":1},{\"timestamp\":1674258120,\"stat\":1},{\"timestamp\":1674258060,\"stat\":1},{\"timestamp\":1674258000,\"stat\":1},{\"timestamp\":1674257940,\"stat\":1},{\"timestamp\":1674257880,\"stat\":1},{\"timestamp\":1674257820,\"stat\":1},{\"timestamp\":1674257760,\"stat\":1},{\"timestamp\":1674257700,\"stat\":1},{\"timestamp\":1674257640,\"stat\":1},{\"timestamp\":1674257580,\"stat\":1},{\"timestamp\":1674257520,\"stat\":1},{\"timestamp\":1674257460,\"stat\":1},{\"timestamp\":1674257400,\"stat\":1},{\"timestamp\":1674257340,\"stat\":1},{\"timestamp\":1674257280,\"stat\":1},{\"timestamp\":1674257220,\"stat\":1},{\"timestamp\":1674257160,\"stat\":1},{\"timestamp\":1674257100,\"stat\":1},{\"timestamp\":1674257040,\"stat\":1},{\"timestamp\":1674256980,\"stat\":1},{\"timestamp\":1674256920,\"stat\":1},{\"timestamp\":1674256860,\"stat\":1},{\"timestamp\":1674256800,\"stat\":1},{\"timestamp\":1674256740,\"stat\":1},{\"timestamp\":1674256680,\"stat\":1},{\"timestamp\":1674256620,\"stat\":1},{\"timestamp\":1674256560,\"stat\":1},{\"timestamp\":1674256500,\"stat\":1},{\"timestamp\":1674256440,\"stat\":1},{\"timestamp\":1674256380,\"stat\":1},{\"timestamp\":1674256320,\"stat\":1},{\"timestamp\":1674256260,\"stat\":1},{\"timestamp\":1674256200,\"stat\":1},{\"timestamp\":1674256140,\"stat\":1},{\"timestamp\":1674256080,\"stat\":1},{\"timestamp\":1674256020,\"stat\":1},{\"timestamp\":1674255960,\"stat\":1},{\"timestamp\":1674255900,\"stat\":1},{\"timestamp\":1674255840,\"stat\":1},{\"timestamp\":1674255780,\"stat\":1},{\"timestamp\":1674255720,\"stat\":1},{\"timestamp\":1674255660,\"stat\":1},{\"timestamp\":1674255600,\"stat\":1},{\"timestamp\":1674255540,\"stat\":1},{\"timestamp\":1674255480,\"stat\":1},{\"timestamp\":1674255420,\"stat\":1},{\"timestamp\":1674255360,\"stat\":1},{\"timestamp\":1674255300,\"stat\":1},{\"timestamp\":1674255240,\"stat\":1},{\"timestamp\":1674255180,\"stat\":1},{\"timestamp\":1674255120,\"stat\":1},{\"timestamp\":1674255060,\"stat\":1},{\"timestamp\":1674255000,\"stat\":1},{\"timestamp\":1674254940,\"stat\":1},{\"timestamp\":1674254880,\"stat\":1},{\"timestamp\":1674254820,\"stat\":1},{\"timestamp\":1674254760,\"stat\":1},{\"timestamp\":1674254700,\"stat\":1},{\"timestamp\":1674254640,\"stat\":1},{\"timestamp\":1674254580,\"stat\":1},{\"timestamp\":1674254520,\"stat\":1},{\"timestamp\":1674254460,\"stat\":1},{\"timestamp\":1674254400,\"stat\":1},{\"timestamp\":1674254340,\"stat\":1},{\"timestamp\":1674254280,\"stat\":1},{\"timestamp\":1674254220,\"stat\":1},{\"timestamp\":1674254160,\"stat\":1},{\"timestamp\":1674254100,\"stat\":1},{\"timestamp\":1674254040,\"stat\":1},{\"timestamp\":1674253980,\"stat\":1},{\"timestamp\":1674253920,\"stat\":1},{\"timestamp\":1674253860,\"stat\":1},{\"timestamp\":1674253800,\"stat\":1},{\"timestamp\":1674253740,\"stat\":1},{\"timestamp\":1674253680,\"stat\":1},{\"timestamp\":1674253620,\"stat\":1},{\"timestamp\":1674253560,\"stat\":1},{\"timestamp\":1674253500,\"stat\":1},{\"timestamp\":1674253440,\"stat\":1},{\"timestamp\":1674253380,\"stat\":1},{\"timestamp\":1674253320,\"stat\":1},{\"timestamp\":1674253260,\"stat\":1},{\"timestamp\":1674253200,\"stat\":1},{\"timestamp\":1674253140,\"stat\":1},{\"timestamp\":1674253080,\"stat\":1},{\"timestamp\":1674253020,\"stat\":0},{\"timestamp\":1674252960,\"stat\":0},{\"timestamp\":1674252900,\"stat\":1},{\"timestamp\":1674252840,\"stat\":1},{\"timestamp\":1674252780,\"stat\":0},{\"timestamp\":1674252720,\"stat\":0},{\"timestamp\":1674252660,\"stat\":0},{\"timestamp\":1674252600,\"stat\":1},{\"timestamp\":1674252540,\"stat\":0},{\"timestamp\":1674252480,\"stat\":0},{\"timestamp\":1674252420,\"stat\":1},{\"timestamp\":1674252360,\"stat\":1},{\"timestamp\":1674252300,\"stat\":1},{\"timestamp\":1674252240,\"stat\":1},{\"timestamp\":1674252180,\"stat\":1},{\"timestamp\":1674252120,\"stat\":1},{\"timestamp\":1674252060,\"stat\":1},{\"timestamp\":1674252000,\"stat\":1},{\"timestamp\":1674251940,\"stat\":1},{\"timestamp\":1674251880,\"stat\":1},{\"timestamp\":1674251820,\"stat\":0},{\"timestamp\":1674251760,\"stat\":0},{\"timestamp\":1674251700,\"stat\":0},{\"timestamp\":1674251640,\"stat\":0},{\"timestamp\":1674251580,\"stat\":0},{\"timestamp\":1674251520,\"stat\":0},{\"timestamp\":1674251460,\"stat\":0},{\"timestamp\":1674251400,\"stat\":0},{\"timestamp\":1674251340,\"stat\":0},{\"timestamp\":1674251280,\"stat\":0},{\"timestamp\":1674251220,\"stat\":0},{\"timestamp\":1674251160,\"stat\":0},{\"timestamp\":1674251100,\"stat\":0},{\"timestamp\":1674251040,\"stat\":0},{\"timestamp\":1674250980,\"stat\":0},{\"timestamp\":1674250920,\"stat\":0},{\"timestamp\":1674250860,\"stat\":0},{\"timestamp\":1674250800,\"stat\":0},{\"timestamp\":1674250740,\"stat\":0},{\"timestamp\":1674250680,\"stat\":0},{\"timestamp\":1674250620,\"stat\":0},{\"timestamp\":1674250560,\"stat\":0},{\"timestamp\":1674250500,\"stat\":0},{\"timestamp\":1674250440,\"stat\":0},{\"timestamp\":1674250380,\"stat\":0},{\"timestamp\":1674250320,\"stat\":0},{\"timestamp\":1674250260,\"stat\":0},{\"timestamp\":1674250200,\"stat\":0},{\"timestamp\":1674250140,\"stat\":0},{\"timestamp\":1674250080,\"stat\":0},{\"timestamp\":1674250020,\"stat\":0},{\"timestamp\":1674249960,\"stat\":0},{\"timestamp\":1674249900,\"stat\":0},{\"timestamp\":1674249840,\"stat\":0},{\"timestamp\":1674249780,\"stat\":0},{\"timestamp\":1674249720,\"stat\":0},{\"timestamp\":1674249660,\"stat\":0},{\"timestamp\":1674249600,\"stat\":0},{\"timestamp\":1674249540,\"stat\":0},{\"timestamp\":1674249480,\"stat\":0},{\"timestamp\":1674249420,\"stat\":0},{\"timestamp\":1674249360,\"stat\":0},{\"timestamp\":1674249300,\"stat\":0},{\"timestamp\":1674249240,\"stat\":0},{\"timestamp\":1674249180,\"stat\":0},{\"timestamp\":1674249120,\"stat\":0},{\"timestamp\":1674249060,\"stat\":0},{\"timestamp\":1674249000,\"stat\":0},{\"timestamp\":1674248940,\"stat\":0},{\"timestamp\":1674248880,\"stat\":0},{\"timestamp\":1674248820,\"stat\":0},{\"timestamp\":1674248760,\"stat\":0},{\"timestamp\":1674248700,\"stat\":0},{\"timestamp\":1674248640,\"stat\":0},{\"timestamp\":1674248580,\"stat\":0},{\"timestamp\":1674248520,\"stat\":0},{\"timestamp\":1674248460,\"stat\":0},{\"timestamp\":1674248400,\"stat\":0},{\"timestamp\":1674248340,\"stat\":0},{\"timestamp\":1674248280,\"stat\":0},{\"timestamp\":1674248220,\"stat\":0},{\"timestamp\":1674248160,\"stat\":0},{\"timestamp\":1674248100,\"stat\":0},{\"timestamp\":1674248040,\"stat\":0},{\"timestamp\":1674247980,\"stat\":0},{\"timestamp\":1674247920,\"stat\":0},{\"timestamp\":1674247860,\"stat\":0},{\"timestamp\":1674247800,\"stat\":0},{\"timestamp\":1674247740,\"stat\":0},{\"timestamp\":1674247680,\"stat\":0},{\"timestamp\":1674247620,\"stat\":0},{\"timestamp\":1674247560,\"stat\":0},{\"timestamp\":1674247500,\"stat\":0},{\"timestamp\":1674247440,\"stat\":0},{\"timestamp\":1674247380,\"stat\":0},{\"timestamp\":1674247320,\"stat\":0},{\"timestamp\":1674247260,\"stat\":1},{\"timestamp\":1674247200,\"stat\":1},{\"timestamp\":1674247140,\"stat\":0},{\"timestamp\":1674247080,\"stat\":0},{\"timestamp\":1674247020,\"stat\":0},{\"timestamp\":1674246960,\"stat\":0},{\"timestamp\":1674246900,\"stat\":0},{\"timestamp\":1674246840,\"stat\":0},{\"timestamp\":1674246780,\"stat\":0},{\"timestamp\":1674246720,\"stat\":1},{\"timestamp\":1674246660,\"stat\":0},{\"timestamp\":1674246600,\"stat\":0},{\"timestamp\":1674246540,\"stat\":0},{\"timestamp\":1674246480,\"stat\":1},{\"timestamp\":1674246420,\"stat\":1},{\"timestamp\":1674246360,\"stat\":0},{\"timestamp\":1674246300,\"stat\":1},{\"timestamp\":1674246240,\"stat\":1},{\"timestamp\":1674246180,\"stat\":1},{\"timestamp\":1674246120,\"stat\":1},{\"timestamp\":1674246060,\"stat\":1},{\"timestamp\":1674246000,\"stat\":1},{\"timestamp\":1674245940,\"stat\":1},{\"timestamp\":1674245880,\"stat\":1},{\"timestamp\":1674245820,\"stat\":1},{\"timestamp\":1674245760,\"stat\":1},{\"timestamp\":1674245700,\"stat\":1},{\"timestamp\":1674245640,\"stat\":1},{\"timestamp\":1674245580,\"stat\":1},{\"timestamp\":1674245520,\"stat\":1},{\"timestamp\":1674245460,\"stat\":1},{\"timestamp\":1674245400,\"stat\":1},{\"timestamp\":1674245340,\"stat\":1},{\"timestamp\":1674245280,\"stat\":1},{\"timestamp\":1674245220,\"stat\":1},{\"timestamp\":1674245160,\"stat\":1},{\"timestamp\":1674245100,\"stat\":1},{\"timestamp\":1674245040,\"stat\":1},{\"timestamp\":1674244980,\"stat\":1},{\"timestamp\":1674244920,\"stat\":1},{\"timestamp\":1674244860,\"stat\":1},{\"timestamp\":1674244800,\"stat\":0},{\"timestamp\":1674244740,\"stat\":0},{\"timestamp\":1674244680,\"stat\":0},{\"timestamp\":1674244620,\"stat\":0},{\"timestamp\":1674244560,\"stat\":0},{\"timestamp\":1674244500,\"stat\":1},{\"timestamp\":1674244440,\"stat\":1},{\"timestamp\":1674244380,\"stat\":1},{\"timestamp\":1674244320,\"stat\":1},{\"timestamp\":1674244260,\"stat\":1},{\"timestamp\":1674244200,\"stat\":1},{\"timestamp\":1674244140,\"stat\":1},{\"timestamp\":1674244080,\"stat\":1},{\"timestamp\":1674244020,\"stat\":1},{\"timestamp\":1674243960,\"stat\":1},{\"timestamp\":1674243900,\"stat\":1},{\"timestamp\":1674243840,\"stat\":1},{\"timestamp\":1674243780,\"stat\":1},{\"timestamp\":1674243720,\"stat\":1},{\"timestamp\":1674243660,\"stat\":1},{\"timestamp\":1674243600,\"stat\":1},{\"timestamp\":1674243540,\"stat\":1},{\"timestamp\":1674243480,\"stat\":1},{\"timestamp\":1674243420,\"stat\":1},{\"timestamp\":1674243360,\"stat\":1},{\"timestamp\":1674243300,\"stat\":1},{\"timestamp\":1674243240,\"stat\":1},{\"timestamp\":1674243180,\"stat\":1},{\"timestamp\":1674243120,\"stat\":1},{\"timestamp\":1674243060,\"stat\":1},{\"timestamp\":1674243000,\"stat\":1},{\"timestamp\":1674242940,\"stat\":1},{\"timestamp\":1674242880,\"stat\":1},{\"timestamp\":1674242820,\"stat\":1},{\"timestamp\":1674242760,\"stat\":1},{\"timestamp\":1674242700,\"stat\":1},{\"timestamp\":1674242640,\"stat\":1},{\"timestamp\":1674242580,\"stat\":1},{\"timestamp\":1674242520,\"stat\":1},{\"timestamp\":1674242460,\"stat\":1},{\"timestamp\":1674242400,\"stat\":1},{\"timestamp\":1674242340,\"stat\":1},{\"timestamp\":1674242280,\"stat\":1},{\"timestamp\":1674242220,\"stat\":1},{\"timestamp\":1674242160,\"stat\":1},{\"timestamp\":1674242100,\"stat\":1},{\"timestamp\":1674242040,\"stat\":0},{\"timestamp\":1674241980,\"stat\":0},{\"timestamp\":1674241920,\"stat\":0},{\"timestamp\":1674241860,\"stat\":1},{\"timestamp\":1674241800,\"stat\":1},{\"timestamp\":1674241740,\"stat\":1},{\"timestamp\":1674241680,\"stat\":1},{\"timestamp\":1674241620,\"stat\":1},{\"timestamp\":1674241560,\"stat\":1},{\"timestamp\":1674241500,\"stat\":1},{\"timestamp\":1674241440,\"stat\":1},{\"timestamp\":1674241380,\"stat\":1},{\"timestamp\":1674241320,\"stat\":1},{\"timestamp\":1674241260,\"stat\":1},{\"timestamp\":1674241200,\"stat\":1},{\"timestamp\":1674241140,\"stat\":1},{\"timestamp\":1674241080,\"stat\":1},{\"timestamp\":1674241020,\"stat\":1},{\"timestamp\":1674240960,\"stat\":0},{\"timestamp\":1674240900,\"stat\":0},{\"timestamp\":1674240840,\"stat\":0},{\"timestamp\":1674240780,\"stat\":0},{\"timestamp\":1674240720,\"stat\":0},{\"timestamp\":1674240660,\"stat\":0},{\"timestamp\":1674240600,\"stat\":1},{\"timestamp\":1674240540,\"stat\":1},{\"timestamp\":1674240480,\"stat\":1},{\"timestamp\":1674240420,\"stat\":1},{\"timestamp\":1674240360,\"stat\":1},{\"timestamp\":1674240300,\"stat\":1},{\"timestamp\":1674240240,\"stat\":1},{\"timestamp\":1674240180,\"stat\":1},{\"timestamp\":1674240120,\"stat\":1},{\"timestamp\":1674240060,\"stat\":1},{\"timestamp\":1674240000,\"stat\":1},{\"timestamp\":1674239940,\"stat\":1},{\"timestamp\":1674239880,\"stat\":1},{\"timestamp\":1674239820,\"stat\":1},{\"timestamp\":1674239760,\"stat\":1},{\"timestamp\":1674239700,\"stat\":1},{\"timestamp\":1674239640,\"stat\":1},{\"timestamp\":1674239580,\"stat\":1},{\"timestamp\":1674239520,\"stat\":1},{\"timestamp\":1674239460,\"stat\":1},{\"timestamp\":1674239400,\"stat\":1},{\"timestamp\":1674239340,\"stat\":0},{\"timestamp\":1674239280,\"stat\":0},{\"timestamp\":1674239220,\"stat\":0},{\"timestamp\":1674239160,\"stat\":0},{\"timestamp\":1674239100,\"stat\":0},{\"timestamp\":1674239040,\"stat\":0},{\"timestamp\":1674238980,\"stat\":0},{\"timestamp\":1674238920,\"stat\":0},{\"timestamp\":1674238860,\"stat\":0},{\"timestamp\":1674238800,\"stat\":0},{\"timestamp\":1674238740,\"stat\":0},{\"timestamp\":1674238680,\"stat\":0},{\"timestamp\":1674238620,\"stat\":1},{\"timestamp\":1674238560,\"stat\":1},{\"timestamp\":1674238500,\"stat\":1},{\"timestamp\":1674238440,\"stat\":1},{\"timestamp\":1674238380,\"stat\":1},{\"timestamp\":1674238320,\"stat\":1},{\"timestamp\":1674238260,\"stat\":1},{\"timestamp\":1674238200,\"stat\":1},{\"timestamp\":1674238140,\"stat\":1},{\"timestamp\":1674238080,\"stat\":1},{\"timestamp\":1674238020,\"stat\":1},{\"timestamp\":1674237960,\"stat\":1},{\"timestamp\":1674237900,\"stat\":0},{\"timestamp\":1674237840,\"stat\":1},{\"timestamp\":1674237780,\"stat\":1},{\"timestamp\":1674237720,\"stat\":1},{\"timestamp\":1674237660,\"stat\":1},{\"timestamp\":1674237600,\"stat\":1},{\"timestamp\":1674237540,\"stat\":1},{\"timestamp\":1674237480,\"stat\":1},{\"timestamp\":1674237420,\"stat\":1},{\"timestamp\":1674237360,\"stat\":1},{\"timestamp\":1674237300,\"stat\":1},{\"timestamp\":1674237240,\"stat\":1},{\"timestamp\":1674237180,\"stat\":1},{\"timestamp\":1674237120,\"stat\":1},{\"timestamp\":1674237060,\"stat\":1},{\"timestamp\":1674237000,\"stat\":0},{\"timestamp\":1674236940,\"stat\":0},{\"timestamp\":1674236880,\"stat\":0},{\"timestamp\":1674236820,\"stat\":1},{\"timestamp\":1674236760,\"stat\":1},{\"timestamp\":1674236700,\"stat\":1},{\"timestamp\":1674236640,\"stat\":1},{\"timestamp\":1674236580,\"stat\":1},{\"timestamp\":1674236520,\"stat\":1},{\"timestamp\":1674236460,\"stat\":1},{\"timestamp\":1674236400,\"stat\":1},{\"timestamp\":1674236340,\"stat\":1},{\"timestamp\":1674236280,\"stat\":1},{\"timestamp\":1674236220,\"stat\":1},{\"timestamp\":1674236160,\"stat\":1},{\"timestamp\":1674236100,\"stat\":1},{\"timestamp\":1674236040,\"stat\":1},{\"timestamp\":1674235980,\"stat\":1},{\"timestamp\":1674235920,\"stat\":1},{\"timestamp\":1674235860,\"stat\":1},{\"timestamp\":1674235800,\"stat\":1},{\"timestamp\":1674235740,\"stat\":1},{\"timestamp\":1674235680,\"stat\":1},{\"timestamp\":1674235620,\"stat\":1},{\"timestamp\":1674235560,\"stat\":1},{\"timestamp\":1674235500,\"stat\":1},{\"timestamp\":1674235440,\"stat\":1},{\"timestamp\":1674235380,\"stat\":1},{\"timestamp\":1674235320,\"stat\":1},{\"timestamp\":1674235260,\"stat\":1},{\"timestamp\":1674235200,\"stat\":1},{\"timestamp\":1674235140,\"stat\":1},{\"timestamp\":1674235080,\"stat\":1},{\"timestamp\":1674235020,\"stat\":1},{\"timestamp\":1674234960,\"stat\":1},{\"timestamp\":1674234900,\"stat\":1},{\"timestamp\":1674234840,\"stat\":1},{\"timestamp\":1674234780,\"stat\":1},{\"timestamp\":1674234720,\"stat\":1},{\"timestamp\":1674234660,\"stat\":1},{\"timestamp\":1674234600,\"stat\":1},{\"timestamp\":1674234540,\"stat\":1},{\"timestamp\":1674234480,\"stat\":1},{\"timestamp\":1674234420,\"stat\":1},{\"timestamp\":1674234360,\"stat\":1},{\"timestamp\":1674234300,\"stat\":1},{\"timestamp\":1674234240,\"stat\":1},{\"timestamp\":1674234180,\"stat\":1},{\"timestamp\":1674234120,\"stat\":1},{\"timestamp\":1674234060,\"stat\":1},{\"timestamp\":1674234000,\"stat\":1},{\"timestamp\":1674233940,\"stat\":1},{\"timestamp\":1674233880,\"stat\":1},{\"timestamp\":1674233820,\"stat\":1},{\"timestamp\":1674233760,\"stat\":1},{\"timestamp\":1674233700,\"stat\":1},{\"timestamp\":1674233640,\"stat\":1},{\"timestamp\":1674233580,\"stat\":1},{\"timestamp\":1674233520,\"stat\":1},{\"timestamp\":1674233460,\"stat\":1},{\"timestamp\":1674233400,\"stat\":1},{\"timestamp\":1674233340,\"stat\":1},{\"timestamp\":1674233280,\"stat\":1},{\"timestamp\":1674233220,\"stat\":1},{\"timestamp\":1674233160,\"stat\":0},{\"timestamp\":1674233100,\"stat\":0},{\"timestamp\":1674233040,\"stat\":0},{\"timestamp\":1674232980,\"stat\":0},{\"timestamp\":1674232920,\"stat\":1},{\"timestamp\":1674232860,\"stat\":1},{\"timestamp\":1674232800,\"stat\":1},{\"timestamp\":1674232740,\"stat\":1},{\"timestamp\":1674232680,\"stat\":1},{\"timestamp\":1674232620,\"stat\":1},{\"timestamp\":1674232560,\"stat\":1},{\"timestamp\":1674232500,\"stat\":1},{\"timestamp\":1674232440,\"stat\":1},{\"timestamp\":1674232380,\"stat\":1},{\"timestamp\":1674232320,\"stat\":1},{\"timestamp\":1674232260,\"stat\":1},{\"timestamp\":1674232200,\"stat\":1}]","payloadType":"json","x":390,"y":1560,"wires":[["c6cd80d8ed0486a9"]]}]

Works great for me:


image

[{"id":"faac50db80c467d0","type":"debug","z":"42aa3359d7ac96f5","name":"debug 130","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":510,"y":580,"wires":[]},{"id":"078aa668f5bf1983","type":"fd-timeline-plot","z":"42aa3359d7ac96f5","fd_container":"a96ede31d15e8fcc","fd_cols":"6","fd_rows":"2","fd_array":false,"fd_array_max":10,"fd_output_topic":"","fd_loopback":false,"name":"","title":"Timeline Plot","popup_info":"","options":{},"data":null,"colors":null,"labels":["hello"],"gradient":null,"show_values":true,"click":true,"x":430,"y":500,"wires":[["5c2d22d02670fbd1"]]},{"id":"2e6adf17eb8275af","type":"function","z":"42aa3359d7ac96f5","name":"prep payload","func":"\nconst pl = msg.payload.sort((a,b) => a.timestamp - b.timestamp)\nconst times = pl.map(v => v.timestamp)\nconst values = pl.map(v => v.stat)\nreturn { payload: [ times, values ] }","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":250,"y":500,"wires":[["078aa668f5bf1983"]]},{"id":"1817ad9ba1e05dc0","type":"inject","z":"42aa3359d7ac96f5","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"timestamp\":1674260940,\"stat\":1},{\"timestamp\":1674260880,\"stat\":1},{\"timestamp\":1674260820,\"stat\":1},{\"timestamp\":1674260760,\"stat\":1},{\"timestamp\":1674260700,\"stat\":1},{\"timestamp\":1674260640,\"stat\":1},{\"timestamp\":1674260580,\"stat\":1},{\"timestamp\":1674260520,\"stat\":1},{\"timestamp\":1674260460,\"stat\":1},{\"timestamp\":1674260400,\"stat\":1},{\"timestamp\":1674260340,\"stat\":1},{\"timestamp\":1674260280,\"stat\":1},{\"timestamp\":1674260220,\"stat\":1},{\"timestamp\":1674260160,\"stat\":1},{\"timestamp\":1674260100,\"stat\":1},{\"timestamp\":1674260040,\"stat\":1},{\"timestamp\":1674259980,\"stat\":1},{\"timestamp\":1674259920,\"stat\":1},{\"timestamp\":1674259860,\"stat\":1},{\"timestamp\":1674259800,\"stat\":1},{\"timestamp\":1674259740,\"stat\":1},{\"timestamp\":1674259680,\"stat\":1},{\"timestamp\":1674259620,\"stat\":1},{\"timestamp\":1674259560,\"stat\":1},{\"timestamp\":1674259500,\"stat\":1},{\"timestamp\":1674259440,\"stat\":1},{\"timestamp\":1674259380,\"stat\":0},{\"timestamp\":1674259320,\"stat\":1},{\"timestamp\":1674259260,\"stat\":1},{\"timestamp\":1674259200,\"stat\":1},{\"timestamp\":1674259140,\"stat\":1},{\"timestamp\":1674259080,\"stat\":1},{\"timestamp\":1674259020,\"stat\":1},{\"timestamp\":1674258960,\"stat\":1},{\"timestamp\":1674258900,\"stat\":1},{\"timestamp\":1674258840,\"stat\":0},{\"timestamp\":1674258780,\"stat\":0},{\"timestamp\":1674258720,\"stat\":0},{\"timestamp\":1674258660,\"stat\":0},{\"timestamp\":1674258600,\"stat\":1},{\"timestamp\":1674258540,\"stat\":1},{\"timestamp\":1674258480,\"stat\":1},{\"timestamp\":1674258420,\"stat\":1},{\"timestamp\":1674258360,\"stat\":1},{\"timestamp\":1674258300,\"stat\":1},{\"timestamp\":1674258240,\"stat\":1},{\"timestamp\":1674258180,\"stat\":1},{\"timestamp\":1674258120,\"stat\":1},{\"timestamp\":1674258060,\"stat\":1},{\"timestamp\":1674258000,\"stat\":1},{\"timestamp\":1674257940,\"stat\":1},{\"timestamp\":1674257880,\"stat\":1},{\"timestamp\":1674257820,\"stat\":1},{\"timestamp\":1674257760,\"stat\":1},{\"timestamp\":1674257700,\"stat\":1},{\"timestamp\":1674257640,\"stat\":1},{\"timestamp\":1674257580,\"stat\":1},{\"timestamp\":1674257520,\"stat\":1},{\"timestamp\":1674257460,\"stat\":1},{\"timestamp\":1674257400,\"stat\":1},{\"timestamp\":1674257340,\"stat\":1},{\"timestamp\":1674257280,\"stat\":1},{\"timestamp\":1674257220,\"stat\":1},{\"timestamp\":1674257160,\"stat\":1},{\"timestamp\":1674257100,\"stat\":1},{\"timestamp\":1674257040,\"stat\":1},{\"timestamp\":1674256980,\"stat\":1},{\"timestamp\":1674256920,\"stat\":1},{\"timestamp\":1674256860,\"stat\":1},{\"timestamp\":1674256800,\"stat\":1},{\"timestamp\":1674256740,\"stat\":1},{\"timestamp\":1674256680,\"stat\":1},{\"timestamp\":1674256620,\"stat\":1},{\"timestamp\":1674256560,\"stat\":1},{\"timestamp\":1674256500,\"stat\":1},{\"timestamp\":1674256440,\"stat\":1},{\"timestamp\":1674256380,\"stat\":1},{\"timestamp\":1674256320,\"stat\":1},{\"timestamp\":1674256260,\"stat\":1},{\"timestamp\":1674256200,\"stat\":1},{\"timestamp\":1674256140,\"stat\":1},{\"timestamp\":1674256080,\"stat\":1},{\"timestamp\":1674256020,\"stat\":1},{\"timestamp\":1674255960,\"stat\":1},{\"timestamp\":1674255900,\"stat\":1},{\"timestamp\":1674255840,\"stat\":1},{\"timestamp\":1674255780,\"stat\":1},{\"timestamp\":1674255720,\"stat\":1},{\"timestamp\":1674255660,\"stat\":1},{\"timestamp\":1674255600,\"stat\":1},{\"timestamp\":1674255540,\"stat\":1},{\"timestamp\":1674255480,\"stat\":1},{\"timestamp\":1674255420,\"stat\":1},{\"timestamp\":1674255360,\"stat\":1},{\"timestamp\":1674255300,\"stat\":1},{\"timestamp\":1674255240,\"stat\":1},{\"timestamp\":1674255180,\"stat\":1},{\"timestamp\":1674255120,\"stat\":1},{\"timestamp\":1674255060,\"stat\":1},{\"timestamp\":1674255000,\"stat\":1},{\"timestamp\":1674254940,\"stat\":1},{\"timestamp\":1674254880,\"stat\":1},{\"timestamp\":1674254820,\"stat\":1},{\"timestamp\":1674254760,\"stat\":1},{\"timestamp\":1674254700,\"stat\":1},{\"timestamp\":1674254640,\"stat\":1},{\"timestamp\":1674254580,\"stat\":1},{\"timestamp\":1674254520,\"stat\":1},{\"timestamp\":1674254460,\"stat\":1},{\"timestamp\":1674254400,\"stat\":1},{\"timestamp\":1674254340,\"stat\":1},{\"timestamp\":1674254280,\"stat\":1},{\"timestamp\":1674254220,\"stat\":1},{\"timestamp\":1674254160,\"stat\":1},{\"timestamp\":1674254100,\"stat\":1},{\"timestamp\":1674254040,\"stat\":1},{\"timestamp\":1674253980,\"stat\":1},{\"timestamp\":1674253920,\"stat\":1},{\"timestamp\":1674253860,\"stat\":1},{\"timestamp\":1674253800,\"stat\":1},{\"timestamp\":1674253740,\"stat\":1},{\"timestamp\":1674253680,\"stat\":1},{\"timestamp\":1674253620,\"stat\":1},{\"timestamp\":1674253560,\"stat\":1},{\"timestamp\":1674253500,\"stat\":1},{\"timestamp\":1674253440,\"stat\":1},{\"timestamp\":1674253380,\"stat\":1},{\"timestamp\":1674253320,\"stat\":1},{\"timestamp\":1674253260,\"stat\":1},{\"timestamp\":1674253200,\"stat\":1},{\"timestamp\":1674253140,\"stat\":1},{\"timestamp\":1674253080,\"stat\":1},{\"timestamp\":1674253020,\"stat\":0},{\"timestamp\":1674252960,\"stat\":0},{\"timestamp\":1674252900,\"stat\":1},{\"timestamp\":1674252840,\"stat\":1},{\"timestamp\":1674252780,\"stat\":0},{\"timestamp\":1674252720,\"stat\":0},{\"timestamp\":1674252660,\"stat\":0},{\"timestamp\":1674252600,\"stat\":1},{\"timestamp\":1674252540,\"stat\":0},{\"timestamp\":1674252480,\"stat\":0},{\"timestamp\":1674252420,\"stat\":1},{\"timestamp\":1674252360,\"stat\":1},{\"timestamp\":1674252300,\"stat\":1},{\"timestamp\":1674252240,\"stat\":1},{\"timestamp\":1674252180,\"stat\":1},{\"timestamp\":1674252120,\"stat\":1},{\"timestamp\":1674252060,\"stat\":1},{\"timestamp\":1674252000,\"stat\":1},{\"timestamp\":1674251940,\"stat\":1},{\"timestamp\":1674251880,\"stat\":1},{\"timestamp\":1674251820,\"stat\":0},{\"timestamp\":1674251760,\"stat\":0},{\"timestamp\":1674251700,\"stat\":0},{\"timestamp\":1674251640,\"stat\":0},{\"timestamp\":1674251580,\"stat\":0},{\"timestamp\":1674251520,\"stat\":0},{\"timestamp\":1674251460,\"stat\":0},{\"timestamp\":1674251400,\"stat\":0},{\"timestamp\":1674251340,\"stat\":0},{\"timestamp\":1674251280,\"stat\":0},{\"timestamp\":1674251220,\"stat\":0},{\"timestamp\":1674251160,\"stat\":0},{\"timestamp\":1674251100,\"stat\":0},{\"timestamp\":1674251040,\"stat\":0},{\"timestamp\":1674250980,\"stat\":0},{\"timestamp\":1674250920,\"stat\":0},{\"timestamp\":1674250860,\"stat\":0},{\"timestamp\":1674250800,\"stat\":0},{\"timestamp\":1674250740,\"stat\":0},{\"timestamp\":1674250680,\"stat\":0},{\"timestamp\":1674250620,\"stat\":0},{\"timestamp\":1674250560,\"stat\":0},{\"timestamp\":1674250500,\"stat\":0},{\"timestamp\":1674250440,\"stat\":0},{\"timestamp\":1674250380,\"stat\":0},{\"timestamp\":1674250320,\"stat\":0},{\"timestamp\":1674250260,\"stat\":0},{\"timestamp\":1674250200,\"stat\":0},{\"timestamp\":1674250140,\"stat\":0},{\"timestamp\":1674250080,\"stat\":0},{\"timestamp\":1674250020,\"stat\":0},{\"timestamp\":1674249960,\"stat\":0},{\"timestamp\":1674249900,\"stat\":0},{\"timestamp\":1674249840,\"stat\":0},{\"timestamp\":1674249780,\"stat\":0},{\"timestamp\":1674249720,\"stat\":0},{\"timestamp\":1674249660,\"stat\":0},{\"timestamp\":1674249600,\"stat\":0},{\"timestamp\":1674249540,\"stat\":0},{\"timestamp\":1674249480,\"stat\":0},{\"timestamp\":1674249420,\"stat\":0},{\"timestamp\":1674249360,\"stat\":0},{\"timestamp\":1674249300,\"stat\":0},{\"timestamp\":1674249240,\"stat\":0},{\"timestamp\":1674249180,\"stat\":0},{\"timestamp\":1674249120,\"stat\":0},{\"timestamp\":1674249060,\"stat\":0},{\"timestamp\":1674249000,\"stat\":0},{\"timestamp\":1674248940,\"stat\":0},{\"timestamp\":1674248880,\"stat\":0},{\"timestamp\":1674248820,\"stat\":0},{\"timestamp\":1674248760,\"stat\":0},{\"timestamp\":1674248700,\"stat\":0},{\"timestamp\":1674248640,\"stat\":0},{\"timestamp\":1674248580,\"stat\":0},{\"timestamp\":1674248520,\"stat\":0},{\"timestamp\":1674248460,\"stat\":0},{\"timestamp\":1674248400,\"stat\":0},{\"timestamp\":1674248340,\"stat\":0},{\"timestamp\":1674248280,\"stat\":0},{\"timestamp\":1674248220,\"stat\":0},{\"timestamp\":1674248160,\"stat\":0},{\"timestamp\":1674248100,\"stat\":0},{\"timestamp\":1674248040,\"stat\":0},{\"timestamp\":1674247980,\"stat\":0},{\"timestamp\":1674247920,\"stat\":0},{\"timestamp\":1674247860,\"stat\":0},{\"timestamp\":1674247800,\"stat\":0},{\"timestamp\":1674247740,\"stat\":0},{\"timestamp\":1674247680,\"stat\":0},{\"timestamp\":1674247620,\"stat\":0},{\"timestamp\":1674247560,\"stat\":0},{\"timestamp\":1674247500,\"stat\":0},{\"timestamp\":1674247440,\"stat\":0},{\"timestamp\":1674247380,\"stat\":0},{\"timestamp\":1674247320,\"stat\":0},{\"timestamp\":1674247260,\"stat\":1},{\"timestamp\":1674247200,\"stat\":1},{\"timestamp\":1674247140,\"stat\":0},{\"timestamp\":1674247080,\"stat\":0},{\"timestamp\":1674247020,\"stat\":0},{\"timestamp\":1674246960,\"stat\":0},{\"timestamp\":1674246900,\"stat\":0},{\"timestamp\":1674246840,\"stat\":0},{\"timestamp\":1674246780,\"stat\":0},{\"timestamp\":1674246720,\"stat\":1},{\"timestamp\":1674246660,\"stat\":0},{\"timestamp\":1674246600,\"stat\":0},{\"timestamp\":1674246540,\"stat\":0},{\"timestamp\":1674246480,\"stat\":1},{\"timestamp\":1674246420,\"stat\":1},{\"timestamp\":1674246360,\"stat\":0},{\"timestamp\":1674246300,\"stat\":1},{\"timestamp\":1674246240,\"stat\":1},{\"timestamp\":1674246180,\"stat\":1},{\"timestamp\":1674246120,\"stat\":1},{\"timestamp\":1674246060,\"stat\":1},{\"timestamp\":1674246000,\"stat\":1},{\"timestamp\":1674245940,\"stat\":1},{\"timestamp\":1674245880,\"stat\":1},{\"timestamp\":1674245820,\"stat\":1},{\"timestamp\":1674245760,\"stat\":1},{\"timestamp\":1674245700,\"stat\":1},{\"timestamp\":1674245640,\"stat\":1},{\"timestamp\":1674245580,\"stat\":1},{\"timestamp\":1674245520,\"stat\":1},{\"timestamp\":1674245460,\"stat\":1},{\"timestamp\":1674245400,\"stat\":1},{\"timestamp\":1674245340,\"stat\":1},{\"timestamp\":1674245280,\"stat\":1},{\"timestamp\":1674245220,\"stat\":1},{\"timestamp\":1674245160,\"stat\":1},{\"timestamp\":1674245100,\"stat\":1},{\"timestamp\":1674245040,\"stat\":1},{\"timestamp\":1674244980,\"stat\":1},{\"timestamp\":1674244920,\"stat\":1},{\"timestamp\":1674244860,\"stat\":1},{\"timestamp\":1674244800,\"stat\":0},{\"timestamp\":1674244740,\"stat\":0},{\"timestamp\":1674244680,\"stat\":0},{\"timestamp\":1674244620,\"stat\":0},{\"timestamp\":1674244560,\"stat\":0},{\"timestamp\":1674244500,\"stat\":1},{\"timestamp\":1674244440,\"stat\":1},{\"timestamp\":1674244380,\"stat\":1},{\"timestamp\":1674244320,\"stat\":1},{\"timestamp\":1674244260,\"stat\":1},{\"timestamp\":1674244200,\"stat\":1},{\"timestamp\":1674244140,\"stat\":1},{\"timestamp\":1674244080,\"stat\":1},{\"timestamp\":1674244020,\"stat\":1},{\"timestamp\":1674243960,\"stat\":1},{\"timestamp\":1674243900,\"stat\":1},{\"timestamp\":1674243840,\"stat\":1},{\"timestamp\":1674243780,\"stat\":1},{\"timestamp\":1674243720,\"stat\":1},{\"timestamp\":1674243660,\"stat\":1},{\"timestamp\":1674243600,\"stat\":1},{\"timestamp\":1674243540,\"stat\":1},{\"timestamp\":1674243480,\"stat\":1},{\"timestamp\":1674243420,\"stat\":1},{\"timestamp\":1674243360,\"stat\":1},{\"timestamp\":1674243300,\"stat\":1},{\"timestamp\":1674243240,\"stat\":1},{\"timestamp\":1674243180,\"stat\":1},{\"timestamp\":1674243120,\"stat\":1},{\"timestamp\":1674243060,\"stat\":1},{\"timestamp\":1674243000,\"stat\":1},{\"timestamp\":1674242940,\"stat\":1},{\"timestamp\":1674242880,\"stat\":1},{\"timestamp\":1674242820,\"stat\":1},{\"timestamp\":1674242760,\"stat\":1},{\"timestamp\":1674242700,\"stat\":1},{\"timestamp\":1674242640,\"stat\":1},{\"timestamp\":1674242580,\"stat\":1},{\"timestamp\":1674242520,\"stat\":1},{\"timestamp\":1674242460,\"stat\":1},{\"timestamp\":1674242400,\"stat\":1},{\"timestamp\":1674242340,\"stat\":1},{\"timestamp\":1674242280,\"stat\":1},{\"timestamp\":1674242220,\"stat\":1},{\"timestamp\":1674242160,\"stat\":1},{\"timestamp\":1674242100,\"stat\":1},{\"timestamp\":1674242040,\"stat\":0},{\"timestamp\":1674241980,\"stat\":0},{\"timestamp\":1674241920,\"stat\":0},{\"timestamp\":1674241860,\"stat\":1},{\"timestamp\":1674241800,\"stat\":1},{\"timestamp\":1674241740,\"stat\":1},{\"timestamp\":1674241680,\"stat\":1},{\"timestamp\":1674241620,\"stat\":1},{\"timestamp\":1674241560,\"stat\":1},{\"timestamp\":1674241500,\"stat\":1},{\"timestamp\":1674241440,\"stat\":1},{\"timestamp\":1674241380,\"stat\":1},{\"timestamp\":1674241320,\"stat\":1},{\"timestamp\":1674241260,\"stat\":1},{\"timestamp\":1674241200,\"stat\":1},{\"timestamp\":1674241140,\"stat\":1},{\"timestamp\":1674241080,\"stat\":1},{\"timestamp\":1674241020,\"stat\":1},{\"timestamp\":1674240960,\"stat\":0},{\"timestamp\":1674240900,\"stat\":0},{\"timestamp\":1674240840,\"stat\":0},{\"timestamp\":1674240780,\"stat\":0},{\"timestamp\":1674240720,\"stat\":0},{\"timestamp\":1674240660,\"stat\":0},{\"timestamp\":1674240600,\"stat\":1},{\"timestamp\":1674240540,\"stat\":1},{\"timestamp\":1674240480,\"stat\":1},{\"timestamp\":1674240420,\"stat\":1},{\"timestamp\":1674240360,\"stat\":1},{\"timestamp\":1674240300,\"stat\":1},{\"timestamp\":1674240240,\"stat\":1},{\"timestamp\":1674240180,\"stat\":1},{\"timestamp\":1674240120,\"stat\":1},{\"timestamp\":1674240060,\"stat\":1},{\"timestamp\":1674240000,\"stat\":1},{\"timestamp\":1674239940,\"stat\":1},{\"timestamp\":1674239880,\"stat\":1},{\"timestamp\":1674239820,\"stat\":1},{\"timestamp\":1674239760,\"stat\":1},{\"timestamp\":1674239700,\"stat\":1},{\"timestamp\":1674239640,\"stat\":1},{\"timestamp\":1674239580,\"stat\":1},{\"timestamp\":1674239520,\"stat\":1},{\"timestamp\":1674239460,\"stat\":1},{\"timestamp\":1674239400,\"stat\":1},{\"timestamp\":1674239340,\"stat\":0},{\"timestamp\":1674239280,\"stat\":0},{\"timestamp\":1674239220,\"stat\":0},{\"timestamp\":1674239160,\"stat\":0},{\"timestamp\":1674239100,\"stat\":0},{\"timestamp\":1674239040,\"stat\":0},{\"timestamp\":1674238980,\"stat\":0},{\"timestamp\":1674238920,\"stat\":0},{\"timestamp\":1674238860,\"stat\":0},{\"timestamp\":1674238800,\"stat\":0},{\"timestamp\":1674238740,\"stat\":0},{\"timestamp\":1674238680,\"stat\":0},{\"timestamp\":1674238620,\"stat\":1},{\"timestamp\":1674238560,\"stat\":1},{\"timestamp\":1674238500,\"stat\":1},{\"timestamp\":1674238440,\"stat\":1},{\"timestamp\":1674238380,\"stat\":1},{\"timestamp\":1674238320,\"stat\":1},{\"timestamp\":1674238260,\"stat\":1},{\"timestamp\":1674238200,\"stat\":1},{\"timestamp\":1674238140,\"stat\":1},{\"timestamp\":1674238080,\"stat\":1},{\"timestamp\":1674238020,\"stat\":1},{\"timestamp\":1674237960,\"stat\":1},{\"timestamp\":1674237900,\"stat\":0},{\"timestamp\":1674237840,\"stat\":1},{\"timestamp\":1674237780,\"stat\":1},{\"timestamp\":1674237720,\"stat\":1},{\"timestamp\":1674237660,\"stat\":1},{\"timestamp\":1674237600,\"stat\":1},{\"timestamp\":1674237540,\"stat\":1},{\"timestamp\":1674237480,\"stat\":1},{\"timestamp\":1674237420,\"stat\":1},{\"timestamp\":1674237360,\"stat\":1},{\"timestamp\":1674237300,\"stat\":1},{\"timestamp\":1674237240,\"stat\":1},{\"timestamp\":1674237180,\"stat\":1},{\"timestamp\":1674237120,\"stat\":1},{\"timestamp\":1674237060,\"stat\":1},{\"timestamp\":1674237000,\"stat\":0},{\"timestamp\":1674236940,\"stat\":0},{\"timestamp\":1674236880,\"stat\":0},{\"timestamp\":1674236820,\"stat\":1},{\"timestamp\":1674236760,\"stat\":1},{\"timestamp\":1674236700,\"stat\":1},{\"timestamp\":1674236640,\"stat\":1},{\"timestamp\":1674236580,\"stat\":1},{\"timestamp\":1674236520,\"stat\":1},{\"timestamp\":1674236460,\"stat\":1},{\"timestamp\":1674236400,\"stat\":1},{\"timestamp\":1674236340,\"stat\":1},{\"timestamp\":1674236280,\"stat\":1},{\"timestamp\":1674236220,\"stat\":1},{\"timestamp\":1674236160,\"stat\":1},{\"timestamp\":1674236100,\"stat\":1},{\"timestamp\":1674236040,\"stat\":1},{\"timestamp\":1674235980,\"stat\":1},{\"timestamp\":1674235920,\"stat\":1},{\"timestamp\":1674235860,\"stat\":1},{\"timestamp\":1674235800,\"stat\":1},{\"timestamp\":1674235740,\"stat\":1},{\"timestamp\":1674235680,\"stat\":1},{\"timestamp\":1674235620,\"stat\":1},{\"timestamp\":1674235560,\"stat\":1},{\"timestamp\":1674235500,\"stat\":1},{\"timestamp\":1674235440,\"stat\":1},{\"timestamp\":1674235380,\"stat\":1},{\"timestamp\":1674235320,\"stat\":1},{\"timestamp\":1674235260,\"stat\":1},{\"timestamp\":1674235200,\"stat\":1},{\"timestamp\":1674235140,\"stat\":1},{\"timestamp\":1674235080,\"stat\":1},{\"timestamp\":1674235020,\"stat\":1},{\"timestamp\":1674234960,\"stat\":1},{\"timestamp\":1674234900,\"stat\":1},{\"timestamp\":1674234840,\"stat\":1},{\"timestamp\":1674234780,\"stat\":1},{\"timestamp\":1674234720,\"stat\":1},{\"timestamp\":1674234660,\"stat\":1},{\"timestamp\":1674234600,\"stat\":1},{\"timestamp\":1674234540,\"stat\":1},{\"timestamp\":1674234480,\"stat\":1},{\"timestamp\":1674234420,\"stat\":1},{\"timestamp\":1674234360,\"stat\":1},{\"timestamp\":1674234300,\"stat\":1},{\"timestamp\":1674234240,\"stat\":1},{\"timestamp\":1674234180,\"stat\":1},{\"timestamp\":1674234120,\"stat\":1},{\"timestamp\":1674234060,\"stat\":1},{\"timestamp\":1674234000,\"stat\":1},{\"timestamp\":1674233940,\"stat\":1},{\"timestamp\":1674233880,\"stat\":1},{\"timestamp\":1674233820,\"stat\":1},{\"timestamp\":1674233760,\"stat\":1},{\"timestamp\":1674233700,\"stat\":1},{\"timestamp\":1674233640,\"stat\":1},{\"timestamp\":1674233580,\"stat\":1},{\"timestamp\":1674233520,\"stat\":1},{\"timestamp\":1674233460,\"stat\":1},{\"timestamp\":1674233400,\"stat\":1},{\"timestamp\":1674233340,\"stat\":1},{\"timestamp\":1674233280,\"stat\":1},{\"timestamp\":1674233220,\"stat\":1},{\"timestamp\":1674233160,\"stat\":0},{\"timestamp\":1674233100,\"stat\":0},{\"timestamp\":1674233040,\"stat\":0},{\"timestamp\":1674232980,\"stat\":0},{\"timestamp\":1674232920,\"stat\":1},{\"timestamp\":1674232860,\"stat\":1},{\"timestamp\":1674232800,\"stat\":1},{\"timestamp\":1674232740,\"stat\":1},{\"timestamp\":1674232680,\"stat\":1},{\"timestamp\":1674232620,\"stat\":1},{\"timestamp\":1674232560,\"stat\":1},{\"timestamp\":1674232500,\"stat\":1},{\"timestamp\":1674232440,\"stat\":1},{\"timestamp\":1674232380,\"stat\":1},{\"timestamp\":1674232320,\"stat\":1},{\"timestamp\":1674232260,\"stat\":1},{\"timestamp\":1674232200,\"stat\":1}]","payloadType":"json","x":90,"y":500,"wires":[["2e6adf17eb8275af"]]},{"id":"5c2d22d02670fbd1","type":"function","z":"42aa3359d7ac96f5","name":"cvt ttime","func":"msg.payload.at = (new Date(msg.payload.time*1000)).toISOString()\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":460,"y":540,"wires":[["faac50db80c467d0"]]},{"id":"a96ede31d15e8fcc","type":"flexdash container","name":"Repro","title":"","kind":"StdGrid","fd_children":",7d8110bad209c9b4,e7c4f917522b9e07,73d471ead270d371,0ca10a099f0a6969,1d8ee88fedb20405,e0dc4b448dc085ca,78673e91a6b52f72,e9b320e81e2e1981,e7b8b8127072bebb,078aa668f5bf1983","tab":"1e908252f3517797","min_cols":"6","max_cols":"20","unicast":"ignore","parent":"","solid":false,"cols":"1","rows":"1"},{"id":"1e908252f3517797","type":"flexdash tab","name":"Repros","icon":"mdi-view-dashboard","title":"Repro","fd_children":",a96ede31d15e8fcc","fd":"e8f5aea52ab49500"}]

If I were you I'd add an "order by" clause to all my DB queries...

2 Likes

The time conversion to local time is fixed now with your function node converting payload.time to payload.at
however, i still see the black lines, i can live with that, they are only like label ticks on x-axis, earlier i wasn't able to see that since the time line axis labels appear only when the widget size is 2 rows height at-least and i was working with only one row. any chance of getting axis labels with 1 row height since it takes too much space in the dashboard.

Note; I have updated to 0.4.142

I do have an order by clause on timestamp field.

select unix_timestamp(datetime) as timestamp, if(state="FALSE",0,1) as stat from tempa order by timestamp desc limit 480;

Yeah, but you're using desc, which means that everything is ordered in reverse order, just the opposite of what you need. Hence the black lines and other issues.

1 Like

I hadn't noticed, hmmm. The labels are actually drawn but they fall outside of the space available and are clipped. Not sure how to make things fit, I'll have to fiddle with it. In the meantime, if you omit the title you get half the axis in:

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