# How to create a time-based query grouped by days?
**URL:** https://discuss.elastic.co/t/how-to-create-a-time-based-query-grouped-by-days/122895
**Category:** Elasticsearch
**Created:** [March 7, 2018, 2:12pm UTC](https://discuss.elastic.co/t/how-to-create-a-time-based-query-grouped-by-days/122895 "2018-03-07T14:12:24Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Jan\_Pisl](https://discuss.elastic.co/u/Jan_Pisl)
#### Post date: [March 7, 2018, 2:12pm UTC](https://discuss.elastic.co/t/how-to-create-a-time-based-query-grouped-by-days/122895/1 "2018-03-07T14:12:24Z")
I need a query that would return data from the last year, grouped by days. So far I have written a query that returns data for the entire year (I hope its correct), but I dont know how to group the data by day.
```
"query" : {
"range" : {
"timestamp" : {
"gt" : "2017-01-01 00:00:00",
"lt" : "2018-01-01 00:00:00"
}
}
}
```
Any help would be much appreciated.
I am using Elasticsearch 6.2.2.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 7, 2018, 4:08pm UTC](https://discuss.elastic.co/t/how-to-create-a-time-based-query-grouped-by-days/122895/2 "2018-03-07T16:08:34Z")
You need to add a `date_histogram` aggregation and ask for a `day` interval.
This will compute buckets per day on the resultset.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 4, 2018, 4:09pm UTC](https://discuss.elastic.co/t/how-to-create-a-time-based-query-grouped-by-days/122895/3 "2018-04-04T16:09:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.