# How to use actual timestamp or createdtime in Table lens without interval

**URL:** <https://discuss.elastic.co/t/how-to-use-actual-timestamp-or-createdtime-in-table-lens-without-interval/326843>\
**Category:** Kibana\
**Tags:** lens\
**Created:** [March 2, 2023, 11:51am UTC](https://discuss.elastic.co/t/how-to-use-actual-timestamp-or-createdtime-in-table-lens-without-interval/326843 "2023-03-02T11:51:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PappuSingh](https://avatars.discourse-cdn.com/v4/letter/p/ea666f/32.png) [@PappuSingh](https://discuss.elastic.co/u/PappuSingh)\
**Post date:** [March 2, 2023, 11:51am UTC](https://discuss.elastic.co/t/how-to-use-actual-timestamp-or-createdtime-in-table-lens-without-interval/326843/1 "2023-03-02T11:51:58Z")

</div>

Hi,

How to show actual timestamp or createdTime on table lens which is available in the index.  
In the below snap highlighted column not showing the actual time which is available in the index, it is showing interval time. please see the below snap for your reference.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f4aa8f89fd98e0cce8e9dfada0a14e60b05219c6.png)

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [March 2, 2023, 1:50pm UTC](https://discuss.elastic.co/t/how-to-use-actual-timestamp-or-createdtime-in-table-lens-without-interval/326843/2 "2023-03-02T13:50:34Z")

</div>

Hi @PappuSingh

you have to define as Metric, using `Last value`.

 ![Screenshot 2023-03-02 at 14.50.13](https://us1.discourse-cdn.com/elastic/original/3X/a/4/a4b65d79942768dc083c01f9b070530d5c92a9b1.png)

---

<div class="post-metadata">

**Author:** ![PappuSingh](https://avatars.discourse-cdn.com/v4/letter/p/ea666f/32.png) [@PappuSingh](https://discuss.elastic.co/u/PappuSingh)\
**Post date:** [March 2, 2023, 2:02pm UTC](https://discuss.elastic.co/t/how-to-use-actual-timestamp-or-createdtime-in-table-lens-without-interval/326843/3 "2023-03-02T14:02:38Z")

</div>

Thank you for your prompt response!!

---

<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:** [March 30, 2023, 2:03pm UTC](https://discuss.elastic.co/t/how-to-use-actual-timestamp-or-createdtime-in-table-lens-without-interval/326843/4 "2023-03-30T14:03:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.