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.
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
I can double click and zoom on the segment though.