I am busy with a project to create real time dashboards for our workflow. Our POC was successful and I'm busy clarifying the final requirements. One thing which I am stumped with is an elapsed time value which I would rather have inside Kibana/elastic search instead of creating over head in SQL. I want to show a real time running time in a HH24:MI:SS format in a column of a table showing the oldest piece of work and how long it has been there until the next update moves it to the next queue/pool. Any suggestions?
In my logstash I have a TransitionTime which is a timestamp
Thanks in advance