# Kibana4: How to set "EventTime" as time field instead of @timestamp

**URL:** <https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693>\
**Category:** Kibana\
**Created:** [July 16, 2015, 6:05am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693 "2015-07-16T06:05:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sunilmchaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunilmchaudhari/32/9475_2.png) [@sunilmchaudhari](https://discuss.elastic.co/u/sunilmchaudhari)\
**Post date:** [July 16, 2015, 6:05am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/1 "2015-07-16T06:05:31Z")

</div>

Hi,  
I am using Kibana4.  
I have one customized time field in db ("EventTime") and @timestamp as default entry time.  
EventTime the timestamp when even was created in the log file at source.  
I want EventTime as timefiled so that user can select time in quick view as per the log file.

1. Can anybody help me to bring down the delay happening in EventTime and entry.time (@timestamp) ?  
I expect it to happen in real time. There is Shipper--\>broker--\>Indexer-\>nGinx in between LSF and ES.

thanks  
Sunil

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [July 16, 2015, 5:58pm UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/2 "2015-07-16T17:58:59Z")

</div>

Hi Sunil - The question you posed is not completely clear to me. What do you mean by the "bring down the delay"? Could you elaborate?

---

<div class="post-metadata">

**Author:** ![sunilmchaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunilmchaudhari/32/9475_2.png) [@sunilmchaudhari](https://discuss.elastic.co/u/sunilmchaudhari)\
**Post date:** [July 17, 2015, 3:15am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/3 "2015-07-17T03:15:49Z")

</div>

Hello Tanya,

about delay part:  
see for example below log in application log file:

**2015-07-16 10:08:49** ERROR [] [org.springframework.security.web.FilterChainProxy] - Some Error with statctrace

I called this timestamp as event log time. I am storing it under the customized field "eventTime". There is another time (@timestamp) created internally which is nothing but the entry time of the event in the datastore.

Ideally this time should be almost same (may be the diff in only few seconds). But in my system, the difference is in minutes. This might be due to middlewares like shipper, broker indexer, load balancers.  
Sometimes the log created on 13th July stored on 14th July. this may happen at the time of date change (around midnight). This is the delay I am talking about. And I want this delay to be as minimum as possible.

That's why I want event log time as new field and the calendar should work on this field only, so that user can search the error logs correctly by selecting most possible combination of from and to date with timestamp.  
Example: to search the stacktrace of error above, he will select the date 16th july from calendar and timestamp in between 10:07:00 and 10:09:00 .

br,  
Sunil

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [July 17, 2015, 3:33am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/4 "2015-07-17T03:33:01Z")

</div>

Thanks for the additional detail.

> [@sunilmchaudhari](#):
>
> That's why I want event log time as new field and the calendar should work on this field only, so that user can search the error logs correctly by selecting most possible combination of from and to date with timestamp.

You should be able to accomplish this by setting "EventTime" as the Time-Field Name - this is the field that will be used to filter using the default time-picker.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/b/be914bec92f437373f995c89033c279fe12c2e5a.png)

Regarding how to bring down the delay, I'd consider posting this question in the Logstash forum - I agree with you that it's likely caused by some component between LSF and ES 🙂

---

<div class="post-metadata">

**Author:** ![sunilmchaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunilmchaudhari/32/9475_2.png) [@sunilmchaudhari](https://discuss.elastic.co/u/sunilmchaudhari)\
**Post date:** [July 17, 2015, 4:19am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/5 "2015-07-17T04:19:49Z")

</div>

Hi Tanya,  
Thanks for quick reply.  
I can see only @timestamp field not any other field. Do I need to set any extra property while creating that field in filter?

 ![](https://us1.discourse-cdn.com/elastic/original/2X/2/2a0006c01dca90fca5fa6e6b1613fc99f17706ef.png)

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [July 17, 2015, 4:36am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/6 "2015-07-17T04:36:10Z")

</div>

It just has to be of type "date" in your mappings -- then it should automatically show up.

---

<div class="post-metadata">

**Author:** ![sunilmchaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunilmchaudhari/32/9475_2.png) [@sunilmchaudhari](https://discuss.elastic.co/u/sunilmchaudhari)\
**Post date:** [July 17, 2015, 6:40am UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/7 "2015-07-17T06:40:59Z")

</div>

Hi Tanya,  
I have created one field evenTime and its being created now. But I cant see it in the left pane. Plz see screenshot which shows highlighted customized field under '\_source' but not in left pane field list. why so?

 ![](https://us1.discourse-cdn.com/elastic/original/2X/7/72ccda83c231b51b8e5e5d5197cc8582df535541.png)  
br,  
Sunil

---

<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:16pm UTC](https://discuss.elastic.co/t/kibana4-how-to-set-eventtime-as-time-field-instead-of-timestamp/25693/8 "2017-07-06T14:16:22Z")

</div>


