# Scripted Date Aggs
**URL:** https://discuss.elastic.co/t/scripted-date-aggs/35338
**Category:** Elasticsearch
**Created:** [November 23, 2015, 6:12pm UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338 "2015-11-23T18:12:36Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@voipoclay](https://discuss.elastic.co/u/voipoclay)
#### Post date: [November 23, 2015, 6:12pm UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/1 "2015-11-23T18:12:36Z")
Hello,
How can I take my @timestamp field and get the hourOfDay count over a period?
In other words I would like to see how many records have a timestamp for each hour of the day.
I am running elasticsearch 2.0
Thanks in advance!
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 24, 2015, 6:58am UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/2 "2015-11-24T06:58:58Z")
Best way I have found to do this is to point KB to your ES cluster and then build a viz that matches what you want to see, then check the query it creates.
---
### Author:  [@voipoclay](https://discuss.elastic.co/u/voipoclay)
#### Post date: [November 24, 2015, 7:17am UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/3 "2015-11-24T07:17:02Z")
I read that kibana 4.2 no longer supports groovy scripts.
Like in this article [https://www.elastic.co/blog/kibana-4-beta-3-now-more-filtery](https://www.elastic.co/blog/kibana-4-beta-3-now-more-filtery)
---
### Author:  [@liweigao](https://discuss.elastic.co/u/liweigao)
#### Post date: [November 24, 2015, 8:38am UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/4 "2015-11-24T08:38:02Z")
hello ,See your problem, I have a question, I want to filter the time, how to do? thanks
---
### Author:  [@colings86](https://discuss.elastic.co/u/colings86)
#### Post date: [November 24, 2015, 6:40pm UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/5 "2015-11-24T18:40:41Z")
@liweigao Please ask your question in a new separate topic so that this topic does not get sidetracked into two different discussions.
---
### Author:  [@Joshua\_P](https://discuss.elastic.co/u/Joshua_P)
#### Post date: [November 24, 2015, 10:37pm UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/6 "2015-11-24T22:37:26Z")
Is a [Date Histogram Aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-datehistogram-aggregation.html) what you're looking for? You can set your time interval to be by the hour.
---
### Author:  [@voipoclay](https://discuss.elastic.co/u/voipoclay)
#### Post date: [November 24, 2015, 10:52pm UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/7 "2015-11-24T22:52:00Z")
I thought that too but that would give me every hour between the dates rather then say the 11th hour of every day combined.
For example if i did 2015-11-01 through 2015-11-07 I would want the 0-24 hour sum.
2015-11-01 11:00:00 +
2015-11-02 11:00:00 +
2015-11-03 11:00:00 +
etc
You used to be able to do it and it would show 24 bars (one for each hour of the day) and add up that hour from every day in the range.
---
### Author:  [@liweigao](https://discuss.elastic.co/u/liweigao)
#### Post date: [November 25, 2015, 1:55am UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/8 "2015-11-25T01:55:24Z")
ok Thank you
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 11:36pm UTC](https://discuss.elastic.co/t/scripted-date-aggs/35338/9 "2017-07-05T23:36:07Z")