# Get the last record for each day
**URL:** https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665
**Category:** Kibana
**Created:** [March 17, 2016, 7:41am UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665 "2016-03-17T07:41:03Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@chenbe2204](https://discuss.elastic.co/u/chenbe2204)
#### Post date: [March 17, 2016, 7:41am UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665/1 "2016-03-17T07:41:03Z")
Hi ,
I want to create a chart that will contain the last record for each day for specific field value.
For example: field name = build\_name
field value = "linux\_32"
I want the aggregation by day
At first I created a search for all those values and used it in the Visualization Chart.
How do you suggest me to get the last record for each day for that field ?
BR,
Chen
---
### Author:  [@Court](https://discuss.elastic.co/u/Court)
#### Post date: [March 17, 2016, 2:10pm UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665/2 "2016-03-17T14:10:25Z")
There isn't support for this built into Kibana, but there's a feature request: [https://github.com/elastic/kibana/issues/678](https://github.com/elastic/kibana/issues/678)
A community member commented about a possible workaround that worked for his use case. Perhaps you could take advantage of a similar approach? [https://github.com/elastic/kibana/issues/678#issuecomment-193945990](https://github.com/elastic/kibana/issues/678#issuecomment-193945990)
---
### Author:  [@chenbe2204](https://discuss.elastic.co/u/chenbe2204)
#### Post date: [March 20, 2016, 5:31am UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665/3 "2016-03-20T05:31:36Z")
Thanks 🙂
I made a work around to solve this issue.
---
### Author:  [@krushnat\_khawale](https://discuss.elastic.co/u/krushnat_khawale)
#### Post date: [March 21, 2016, 9:25am UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665/4 "2016-03-21T09:25:00Z")
@chenbe2204, Would you post what you've mined?
---
### Author:  [@chenbe2204](https://discuss.elastic.co/u/chenbe2204)
#### Post date: [March 23, 2016, 3:35pm UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665/5 "2016-03-23T15:35:24Z")
Hi ,
I uploaded only the files I needed to ElasticSearch.
In that way I have only the records I need.
BR,
Chen
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:58pm UTC](https://discuss.elastic.co/t/get-the-last-record-for-each-day/44665/6 "2017-07-06T13:58:06Z")