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

[SamuelSMendes (Samuel S. Mendes Soares)]

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:

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!

[stephenb (Stephen Brown)]

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

[SamuelSMendes (Samuel S. Mendes Soares)]

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?

[stephenb (Stephen Brown)]

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