# How to make an interval of minutes in a timestamp on Lens \[Dashboards\]

**URL:** <https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123>\
**Category:** Kibana\
**Created:** [August 15, 2022, 7:46pm UTC](https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123 "2022-08-15T19:46:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SamuelSMendes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samuelsmendes/32/104246_2.png) [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\
**Post date:** [August 15, 2022, 7:46pm UTC](https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123/1 "2022-08-15T19:46:42Z")

</div>

Hello everyone, I'm new to the making of dashboards and now I'm having a bit of problem dealing with a specific field on Lens.

First here is the image in question:  
 ![Captura de Tela (943)](https://us1.discourse-cdn.com/elastic/original/3X/2/3/23ef78565653de793c6a9678f7ecbcc76b2c79b2.png)

On the left is a random ID given to a device and on the right is the minute the log of disconection was made.

What I am looking for is a way to only show the interval of such events, so in the example up there would be only:

RQ8M602HR8H and 1minute (since that is the time of the interval).

I'm not sure if there is a already built-in function for that. I know that canvas has a great support for SQL which is nice for cases like this but have yet to see something similar on Dashboards. In any case I'll be glad if there is anyone who can help on that problem, best regards!

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [August 16, 2022, 12:20am UTC](https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123/2 "2022-08-16T00:20:54Z")

</div>

You can hide the Timestamp Column  
Then just add a Metric with formula 1 🙂  
A Hack for Sure ... 🙂

 ![Screen Shot 2022-08-15 at 5.20.34 PM](https://us1.discourse-cdn.com/elastic/original/3X/4/8/4863a7979acdadd44ac59d25e9e2ea58fb404f20.png)

---

<div class="post-metadata">

**Author:** ![SamuelSMendes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samuelsmendes/32/104246_2.png) [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\
**Post date:** [August 16, 2022, 12:49am UTC](https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123/3 "2022-08-16T00:49:59Z")

</div>

Thanks for the fast answer, is about that what I'm looking for but how do I get that formula 1 for the interval in min?

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [August 16, 2022, 1:48am UTC](https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123/4 "2022-08-16T01:48:06Z")

</div>

I didn't I just put  
`1`

In the formula which will always return one and just labeled the column heading... Like I said a hack for sure. Perhaps later I can look at something better

---

<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:** [September 13, 2022, 1:48am UTC](https://discuss.elastic.co/t/how-to-make-an-interval-of-minutes-in-a-timestamp-on-lens-dashboards/312123/5 "2022-09-13T01:48:41Z")

</div>

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