Timezone offset for the day starting at +00:00 after applying an offset

Elastic Stack Elasticsearch
1 
{
    "size": 0,
    "query": {
        "range": {
            "escalationDate": {
                "gte": "now-6d/d",
                "time_zone": "[(${timezoneOffset})]"
            }
        }
    },
    "aggs": {
        "total_escalated_conversations_per_hour_per_week": {
            "date_histogram": {
                "field": "escalationDate",
                "interval": "hour",
                "time_zone": "[(${timezoneOffset})]",
                "extended_bounds": {
                    "min": "now-6d/d",
                    "max": "now+1d/d-1h"
                }
            }
        }
    }
}

Hey, is it possible to have this start at +00:00 for each day after the timezoneOffset has been applied?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.