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?
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