I have date field "local_time": "2020-04-10T23:00:52.000-0600"
which stores the local time (various timezones).
Now I want to use date_histogram
to group data by day but it auto converts the above time to UTC and it will be grouped to 11 April, which is not really correct for me. Because there are many other timezones so I want to group them in the same day in local time.
Client can send all the timezones id but I don't know how to apply to the param timezone in date_histogram
because there are more than 1.
Is there any way to achieve this?