# Aggregation with different timezones

**URL:** <https://discuss.elastic.co/t/aggregation-with-different-timezones/281305>\
**Category:** Elasticsearch\
**Created:** [August 13, 2021, 7:20am UTC](https://discuss.elastic.co/t/aggregation-with-different-timezones/281305 "2021-08-13T07:20:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![scorona85](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@scorona85](https://discuss.elastic.co/u/scorona85)\
**Post date:** [August 13, 2021, 7:20am UTC](https://discuss.elastic.co/t/aggregation-with-different-timezones/281305/1 "2021-08-13T07:20:10Z")

</div>

How can I create an aggregation of datas aquired from different part of Timezones (example New York -6.00 and Rome +2.00). In the document I have a field 'timestamp' defined as "data". I have to create a "date\_histogram" aggregation for example from 8.00 AM to 9.00 AM. How can I aggregate the USA 8.00-9.00 and the ITA 8.00-9.00 datas in order to compare the two data from the same period? ( I expect 8.00-9:00 in whatever local time the record and with a Query the results of USA and ITA from 8:00 - 9:00 (the datas recorded in USA at 8:00-9:00 and ITA at 8:00-9:00).  
Do you have any ideas?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 17, 2021, 1:22am UTC](https://discuss.elastic.co/t/aggregation-with-different-timezones/281305/2 "2021-08-17T01:22:03Z")

</div>

Please don't create multiple topics on the same question, let's continue the discussion here - [Date histogram with different Timezones with Elasticsearch v.7.13.3](https://discuss.elastic.co/t/date-histogram-with-different-timezones-with-elasticsearch-v-7-13-3/280639)

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 17, 2021, 1:22am UTC](https://discuss.elastic.co/t/aggregation-with-different-timezones/281305/3 "2021-08-17T01:22:08Z")

</div>


