# Kibana date range aggregation by year
**URL:** https://discuss.elastic.co/t/kibana-date-range-aggregation-by-year/34024
**Category:** Kibana
**Created:** [November 6, 2015, 5:16pm UTC](https://discuss.elastic.co/t/kibana-date-range-aggregation-by-year/34024 "2015-11-06T17:16:58Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Flavio\_Pompermaier](https://discuss.elastic.co/u/Flavio_Pompermaier)
#### Post date: [November 6, 2015, 5:16pm UTC](https://discuss.elastic.co/t/kibana-date-range-aggregation-by-year/34024/1 "2015-11-06T17:16:58Z")
Hi to all,
in my use case I have an index with 2 date fields (from and to).
I'd like to be able to show the sum of all days covered by such interval aggregated by year...For example, if I have 2 docs in the form \ like the following:
\<1, 2010/01/01,2012/01/30\> and
\<2, 2011/01/01,2011/01/01\> I would like to show
2010: 365
2011: 366
2012: 395
Is it something possible?
Best,
Flavio
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [November 7, 2015, 4:29pm UTC](https://discuss.elastic.co/t/kibana-date-range-aggregation-by-year/34024/2 "2015-11-07T16:29:25Z")
Two options I can think of: (1) use Groovy in Kibana scripted fields to do date math and derive the year field; (2) index the year as a field and do aggregations based on that.
---
### Author:  [@Flavio\_Pompermaier](https://discuss.elastic.co/u/Flavio_Pompermaier)
#### Post date: [November 9, 2015, 8:48am UTC](https://discuss.elastic.co/t/kibana-date-range-aggregation-by-year/34024/3 "2015-11-09T08:48:14Z")
Hi Tanya,
thanks for the answer. I want to compute also the number of days for each year and aggregate that. Do you think it's possible using a scripted field?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:09pm UTC](https://discuss.elastic.co/t/kibana-date-range-aggregation-by-year/34024/4 "2017-07-06T14:09:31Z")