CODEWITHSUNDEEP
dateelasticsearchdata-visualizationkibana-4
Berserk
Berserk

Reputation: 883

Kibana 4 not the good date in visualize menu

I have a problem with visualization of my data on Kibana 4. In discover menu I have the real date that I have insert, but in visualize menu it's not the same date.

This is my data :

{"index":{"_id":"1"}}
{"data1":912914,"date":"2015-01-01","title":"my-title","data2":2939186,"data3":226447}
{"index":{"_id":"2"}}
{"data1":910145,"date":"2015-01-02","title":"my-title","data2":2936572,"data3":225800}
{"index":{"_id":"3"}}
{"data1":917742,"date":"2015-01-03","title":"my-title","data2":2942237,"data3":226889}
{"index":{"_id":"4"}}
{"data1":911823,"date":"2015-01-04","title":"my-title","data2":2925900,"data3":230025}

And the result in discover menu : http://www.hostingpics.net/viewer.php?id=402066Kibanadisco.png

This result is good with the good date, but now in visualize menu : http://www.hostingpics.net/viewer.php?id=566952Kibanavisu.png

So, as you can see, on the second image the date is the date from the day before and note the real date as I want.

Someone can help me to resolve this problem?

Thanks in advance

Upvotes: 1

Views: 142

Answers (1)

Alcanzar
Alcanzar

Reputation: 17155

Elasticsearch stores all dates in GMT.

When kibana displays dates, it displays them in your browsers local time (which appears to be offset from GMT by 1 hour).

If you put the times into ES with the correct time zone it may display them properly, but you have not specified how you are getting the data into ES. If it is with logstash, you could try adding a timezone parameter to your date filter.

Upvotes: 1

Related Questions