Hello :) I have some log data indexed in ES and trying to visualize in Kibana and getting strange behavior related to dates. I have Terms panel with the following settings:
Terms mode: terms Field: date Length 10 Order: count For some reason, the "date" column in the panel is showing up as a long, not a date: COUNTBYDATE TermCountAction146629440000096597 146638080000060063 146620800000059480 The Table panel showing all my log entries knows that field is a date, and it displays as a date correctly. If I curl the request to ES, it appears ES is returning it as a long, not a date: curl -XGET 'http://localhost:9200/test/_search?pretty' -d '{ "facets": { "terms": { "terms": { "field": "date", "size": 10, "order": "count", "exclude": [] }, "facet_filter": { "fquery": { "query": { "filtered": { "query": { "bool": { "should": [ { "query_string": { "query": "_type:test_type" } } ] } }, "filter": { "bool": { "must": [ { "range": { "date": { "from": 1465925902106, "to": 1466769177326 } } } ] } } } } } } } }, "size": 0 }' returns: { "took" : 387, "timed_out" : false, "_shards" : { "total" : 10, "successful" : 10, "failed" : 0 }, "hits" : { "total" : 48173413, "max_score" : 0.0, "hits" : [ ] }, "facets" : { "terms" : { "_type" : "terms", "missing" : 0, "total" : 365090, "other" : 0, "terms" : [ { "term" : 1466294400000, "count" : 96697 }, { "term" : 1466380800000, "count" : 60343 }, { "term" : 1466208000000, "count" : 59579 }, { "term" : 1466121600000, "count" : 51592 }, { "term" : 1466035200000, "count" : 48859 }, { "term" : 1465948800000, "count" : 48020 } ] } } } Is there something I can do to have Kibana recognize the term is a date and display it as "2014-06-17" like the Table panel does? Thanks so much! -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAND3DpjWrZD8xiKCEDzXmcvydoQzztN-4q1%2BVr3rhaH4H0HEUQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.