# How to show data in discover based on EPOCH time

**URL:** <https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378>\
**Category:** Kibana\
**Created:** [March 3, 2016, 12:18pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378 "2016-03-03T12:18:04Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [March 3, 2016, 12:18pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/1 "2016-03-03T12:18:04Z")

</div>

Hi Experts.

I am feeding following data from ES 1.7.1 using bulk API.  
\> POST /clust/clust/\_bulk

> ```
> {"index": {"_index": "clust", "_type": "clust"}}
> {"name": "VG", "rollno": "12", "time": "1457005581"}
> 
> ```

My time filed has EPOCH time in Seconds. I am using following Mapping for this Index  
\> PUT /clust

> ```
> {
> "mappings" : {
> "_default_" : {
> "_all" : {"enabled" : false},
> "properties" : {			
> "time": {"type": "date"}			
> }
> }
> }
> }
> 
> ```

Now problem is when I am configuring an index pattern in kibana 4.1.1 based on time field I got nothing in the discover tab , even I tried to search it for this year.Please suggest what i am missing .

---

<div class="post-metadata">

**Author:** ![Court](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/court/32/6640_2.png) [@Court](https://discuss.elastic.co/u/Court)\
**Post date:** [March 3, 2016, 2:19pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/2 "2016-03-03T14:19:04Z")

</div>

Is the data not showing up under _any_ time interval?

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [March 3, 2016, 3:45pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/3 "2016-03-03T15:45:28Z")

</div>

@Court Nope , it's blank .

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [March 3, 2016, 4:03pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/4 "2016-03-03T16:03:06Z")

</div>

Sorry !! I would have mentioned that with above mapping I am not even see time field in the Kibana drop down while I am creating Index pattern.  
 ![](https://us1.discourse-cdn.com/elastic/original/2X/f/f681ff1374ae6233bcf1314ed0389086ed6ecaa8.png)  
I can only see it when I am converting Epoch to a certain date format . So I should ask first , how I can show this Epoch time(time) in the Kibana drop down without changing it to a certain date format?

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [March 3, 2016, 4:07pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/5 "2016-03-03T16:07:59Z")

</div>

OK, so what I observed when I change mapping like

> PUT clust  
> {  
> "mappings": {  
> "clust": {  
> "properties": {  
> "time": {  
> "type": "date",  
> "format": "yyyy-MM-dd"  
> }  
> }  
> }  
> }  
> }

I can see time field in the kibana drop down , but again no data or document at any time interval in kiaban discover tab. What I conclude , since i am using "format": "yyyy-MM-dd" for time field which is Epoch , they are not mapped ? Please suggest what would be the best format for my epoch time ?

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [March 3, 2016, 6:38pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/6 "2016-03-03T18:38:10Z")

</div>

Finally I figured it out , the problem was with Epoch Seconds format . Found solution here

> <https://github.com/elastic/elasticsearch/issues/4617>

---

<div class="post-metadata">

**Author:** ![Court](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/court/32/6640_2.png) [@Court](https://discuss.elastic.co/u/Court)\
**Post date:** [March 3, 2016, 6:50pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/7 "2016-03-03T18:50:02Z")

</div>

Thanks for updating this with your resolution. I'm sure this will be helpful for other folks as well.

---

<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, 2:00pm UTC](https://discuss.elastic.co/t/how-to-show-data-in-discover-based-on-epoch-time/43378/8 "2017-07-06T14:00:21Z")

</div>