# Get and visualize job execution average duration

**URL:** <https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792>\
**Category:** Logstash\
**Created:** [March 25, 2019, 4:00pm UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792 "2019-03-25T16:00:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\
**Post date:** [March 25, 2019, 4:00pm UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792/1 "2019-03-25T16:00:56Z")

</div>

Hi,

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:

filter{  
date {  
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?

Thanks

---

<div class="post-metadata">

**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\
**Post date:** [March 28, 2019, 3:53pm UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792/2 "2019-03-28T15:53:23Z")

</div>

any update?

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [March 28, 2019, 4:08pm UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792/3 "2019-03-28T16:08:02Z")

</div>

Why not just visualize the job duration in seconds in Kibana?

If you really want to use hours you can convert using a ruby filter.

```
    ruby {
        code => '
            d = event.get("duration")
            if d
                event.set("duration1", d.to_f / 3600)
            end
        '
    }
```

---

<div class="post-metadata">

**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\
**Post date:** [April 9, 2019, 11:49am UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792/4 "2019-04-09T11:49:32Z")

</div>

Thanks Badger,

it worked and now average is displayed in 4,45 format,

is any way how to change this duration format to 'HH:mm:ss' after Kibana calculates duration average?

Thanks

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [April 9, 2019, 11:51am UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792/5 "2019-04-09T11:51:37Z")

</div>

I do not know. That is a kibana question, not a logstash question.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 7, 2019, 11:51am UTC](https://discuss.elastic.co/t/get-and-visualize-job-execution-average-duration/173792/6 "2019-05-07T11:51:39Z")

</div>

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