Wrong Data showing in Grafana for 'Time mode' For Last x days

1

Hi,

I am getting data mismatch when listing for ‘last x days’ with ‘1-day interval’.

Same graph work well for today, yesterday and even for 'day before yesterday with auto interval.

I am using elasticsearch as data source. I have already configured Timezone as ‘Local Browser only’. which is exactly same in which data is stored.

2

Data must be stored in the TSDB (ES in your case) in UTC timezone.

3

Thanks jangaraj, here is the format in which data(apache logs) is stored. Servers are in IST timezone.

timestamp 29/Jan/2019:11:42:30 +0530

Using kibana i am able to get exact count for last x days with 1 days interval. But when it comes through Grafana, it does not match.