# Kibana Terms panel showing date fields as longs?

**URL:** <https://discuss.elastic.co/t/kibana-terms-panel-showing-date-fields-as-longs/18231>\
**Category:** Elasticsearch\
**Created:** [June 20, 2014, 2:39pm UTC](https://discuss.elastic.co/t/kibana-terms-panel-showing-date-fields-as-longs/18231 "2014-06-20T14:39:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Neal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chris_neal/32/3527_2.png) [@Chris\_Neal](https://discuss.elastic.co/u/Chris_Neal)\
**Post date:** [June 20, 2014, 2:39pm UTC](https://discuss.elastic.co/t/kibana-terms-panel-showing-date-fields-as-longs/18231/1 "2014-06-20T14:39:34Z")

</div>

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](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAND3DpjWrZD8xiKCEDzXmcvydoQzztN-4q1%2BVr3rhaH4H0HEUQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAND3DpjWrZD8xiKCEDzXmcvydoQzztN-4q1%2BVr3rhaH4H0HEUQ%40mail.gmail.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:20am UTC](https://discuss.elastic.co/t/kibana-terms-panel-showing-date-fields-as-longs/18231/2 "2017-07-06T01:20:55Z")

</div>