# Get average of response time in specific interval
**URL:** https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828
**Category:** Kibana
**Created:** [May 24, 2016, 11:14am UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828 "2016-05-24T11:14:54Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@ivanandrianto95](https://discuss.elastic.co/u/ivanandrianto95)
#### Post date: [May 24, 2016, 11:14am UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828/1 "2016-05-24T11:14:54Z")
I use Filebeat and ELK and I need to display average of response time in specific interval. It has a field response\_time but I don't know how to get the average response time each minute. How can I do it?
---
### Author:  [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [May 24, 2016, 9:28pm UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828/2 "2016-05-24T21:28:08Z")
You can do a date histogram over an aggregation of the average response time, and set the interval of the histogram to the "Minute" option.
Here's a data table visualization I did (over a "bytes" field since my data doesn't have response time):
---
### Author:  [@ivanandrianto95](https://discuss.elastic.co/u/ivanandrianto95)
#### Post date: [May 25, 2016, 2:13am UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828/3 "2016-05-25T02:13:05Z")
I don't see response\_time in dropdown when I choose average in aggregation
---
### Author:  [@ivanandrianto95](https://discuss.elastic.co/u/ivanandrianto95)
#### Post date: [May 25, 2016, 8:55am UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828/5 "2016-05-25T08:55:40Z")
The problem is in Kibana, the type of response\_time is string even I've converted it to float in logstash.conf
---
### Author:  [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [May 25, 2016, 4:26pm UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828/6 "2016-05-25T16:26:13Z")
The mappings are held in Elasticsearch, Kibana uses those mappings to control what it's able to do with the fields.
Check the mapping for your index by running `curl -XGET "http://hostname:port/logstash-*/_mapping`. If the field is not mapped as a float here, something is going wrong with your logstash.conf.
If your using a `mutate` filter to do the conversion, [this reference](https://discuss.elastic.co/t/convert-string-to-float-failed/32232/3) could be of help.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:52pm UTC](https://discuss.elastic.co/t/get-average-of-response-time-in-specific-interval/50828/7 "2017-07-06T13:52:18Z")