Requests to resolve timezone problems with Grafana and elasticsearch

Hello everyone.

I am using Elasticsearch as datasource.

My timezone is UTC +09: 00.

Grafana does not display data from 00:00 to 09:00 every day.

For example, suppose the time is now 2018-07-02 01:00.

Actual elasticsearch will store the data at index_2018-07-02
When Grafana sends a query to an index, it makes a request with index_2018-07-01.

This state continues until the time in UTC and my timezone passes. 2018-07-02 Data will be displayed normally from 09:00.

The index name on the datasource
“[index_] YYYY_MM_DD” This is set and the pattern is set to “Daily”.

Also, in Time Options on the dashboard, TimeZone is set to “Local browser time”.

Nevertheless, it seems that you are requesting a timestamp based on UTC when you look up data in the chart.

I hope you can help me to see the data properly from 00:00 to 09:00.

Thanks.

1 Like

@jieonlee I have the same problem. Have you solved it?

Put the filter in the date like below in the logstash filter