I am trying to visualize job execution average duration in hours in Kibana.
I query source Duration field from SQL server in Unix format with LogStash filter:
match => [ "duration", "UNIX" ]
target => "duration1"
For example if source epoch number is 9132 instead of 03:56:11 I get full date in the output "1970-01-01T03:56:11.000Z".
How could I filter data to target only to get time (without date) and visualize job execution average duration in hours in Kibana?
Or should I choose different approach for average duration visualization?