# Average responsetime based on services

**URL:** https://discuss.elastic.co/t/average-responsetime-based-on-services/80757
**Category:** Kibana
**Created:** [March 30, 2017, 10:07pm UTC](https://discuss.elastic.co/t/average-responsetime-based-on-services/80757 "2017-03-30T22:07:25Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![cnallapati](https://avatars.discourse-cdn.com/v4/letter/c/58956e/32.png) [@cnallapati](https://discuss.elastic.co/u/cnallapati)
#### Post date: [March 30, 2017, 10:07pm UTC](https://discuss.elastic.co/t/average-responsetime-based-on-services/80757/1 "2017-03-30T22:07:25Z")

</div>

Please see attachment to see how data on kibana discoverer. I am trying to generate table form report based on average response time.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/a/1/a11565ee00343fb45b6f64ecef0bfa18e6ebc45c.JPG)

From above information, I want to generate average response time by grouping Test\_AdminTypes and Test\_Services in a table form. Please advise.

---

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [March 30, 2017, 11:22pm UTC](https://discuss.elastic.co/t/average-responsetime-based-on-services/80757/2 "2017-03-30T23:22:33Z")

</div>

Hi Chaitanya,

I don't have your data of course, but I tried to create something similar. I created a new Data Table visualization and for the Metric, I changed it from Count to Average and selected a numeric type field `event_id` but you would select `response-time`.  
Then I Split Rows by selecting a Terms aggregation and for Field I picked `source_name` but you would pick `Test_AdminTypes` or `Test_Services`

 ![](https://us1.discourse-cdn.com/elastic/original/3X/6/d/6d45f821df459e0f2739ffc2d3ba47b842be820b.png)

You can Split Rows again and select Terms, and you other fields.

Regards,  
Lee

---

<div class="post-metadata">

### Author: ![cnallapati](https://avatars.discourse-cdn.com/v4/letter/c/58956e/32.png) [@cnallapati](https://discuss.elastic.co/u/cnallapati)
#### Post date: [March 31, 2017, 4:33pm UTC](https://discuss.elastic.co/t/average-responsetime-based-on-services/80757/3 "2017-03-31T16:33:23Z")

</div>

Thank you LeeDr.

Unfortunately "response-time" is not shown under Average aggrigarion's filed. But I can see it in Dashboard. Please advise.

Thanks,  
Chaitanya.

---

<div class="post-metadata">

### Author: ![cnallapati](https://avatars.discourse-cdn.com/v4/letter/c/58956e/32.png) [@cnallapati](https://discuss.elastic.co/u/cnallapati)
#### Post date: [March 31, 2017, 9:57pm UTC](https://discuss.elastic.co/t/average-responsetime-based-on-services/80757/4 "2017-03-31T21:57:48Z")

</div>

Hi ,

The field response-time data type is in string and it is not showing under aggregation. How to convert it into number and make it available for aggregation. Please advise.

Thanks,  
Chaitanya.

---

<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: [April 28, 2017, 9:58pm UTC](https://discuss.elastic.co/t/average-responsetime-based-on-services/80757/5 "2017-04-28T21:58:02Z")

</div>

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