Hi, here is the data | delta _time as dlt | eval dlt=abs(dlt) | table _time, state, dlt "_time",state,dlt "2025-03-21T13:25:33.000+0100","Störung", "2025-03-21T13:21:46.000+0100",Verteilzeit,"2...
See more...
Hi, here is the data | delta _time as dlt | eval dlt=abs(dlt) | table _time, state, dlt "_time",state,dlt "2025-03-21T13:25:33.000+0100","Störung", "2025-03-21T13:21:46.000+0100",Verteilzeit,"227.000" "2025-03-21T13:05:01.000+0100","Personal fehlt","1005.000" "2025-03-21T11:23:35.000+0100","Produktion ON","6086.000" "2025-03-21T11:23:19.000+0100",Wartung,"16.000" "2025-03-21T11:21:41.000+0100","Störung","98.000" "2025-03-21T11:20:04.000+0100","Produktion OFF","97.000" "2025-03-21T11:19:57.000+0100","Produktion ON","7.000" "2025-03-21T10:47:01.000+0100","Produktion OFF","1976.000" "2025-03-21T10:46:55.000+0100","Produktion ON","6.000" "2025-03-21T10:46:28.000+0100",Verteilzeit,"27.000" "2025-03-21T10:46:21.000+0100",Verteilzeit,"7.000" There are 7 different signals. Each (state) is comming from the system as an impuls in specific time stamp and represents the state of any workplace. The interval between these signals is the delta (dlt) or duration of the previous state. There is guaranteed no overlapping. I would like to visualise a bar chart of this duration on the timeline. E.g. last 24h. See an example (duration.jpg). Each begin of color is in fact timestamp of the state. If there is any idea, please. This would help me a lot.