Kibana is displaying a previous month instead of the month available in the field

Elastic Stack Kibana
#1

Hello Fellows,

I'm facing a strange situation with Kibana when dealing with datefields with just year and month (YYYY-MM).

The labels in a Chart our List are displaying a datefield with value 2015-07 as "June 30th 2015..." instead of "July 30th 2015..."

The image bellow shows this situation:

Screen Shot 2015-08-17 at 5.15.39 PM.png985×602 104 KB

Anybody knows what may happening?

Thanks in advance!

#2

Is the Time field something you added, or created by ES automatically?

#3

I have added the field.

#4

It could be a TZ issue, are you ahead/behind of UTC?

#5

I'm 3 hours behind utc

#6

Could you paste in the full JSON document, and indicate which "date" type field is mapped as the primary time field?

#7

Hi Tanya,

The field is "access_date"

{
"took": 6131,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
"hits": {
"total": 290890,
"max_score": 1,
"hits": [
{
"_index": "accesses_counter",
"_type": "articles",
"_id": "2015-07_scl_S1984-29612015005015030",
"_score": 1,
"_source": {
"access_epdf": 0,
"access_abstract": 2,
"access_year": "2015",
"access_day": "",
"access_html": 11,
"journal_title": "Revista Brasileira de Parasitologia Veterinária",
"subject_areas": [
"Biological Sciences"
],
"issn": "1984-2961",
"pid": "S1984-29612015005015030",
"access_month": "07",
"publication_year": "2015",
"aff_countries": [
"BR"
],
"languages": [
"en"
],
"collection": "scl",
"access_total": 15,
"publication_date": "2015",
"access_date": "2015-07",
"document_type": "research-article",
"issue": "S1984-296120150050",
"id": "scl_S1984-29612015005015030",
"access_pdf": 2,
"@version": "1",
"@timestamp": "2015-07-24T13:41:32.959Z",
"host": "ratchet.scielo.org",
"path": "/var/www/logstash/logs_counter/scielo_accesses_2015_jun.json"
}
}
]
}
}

#8

So the Time field is usually based off the @timestamp field, unless you specified another date field in the index pattern. "Access Date" is not a full date field. What does your index pattern definition look like for this index?

#9