# TSVB table - Get start date

**URL:** <https://discuss.elastic.co/t/tsvb-table-get-start-date/288025>\
**Category:** Kibana\
**Created:** [October 29, 2021, 5:11pm UTC](https://discuss.elastic.co/t/tsvb-table-get-start-date/288025 "2021-10-29T17:11:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Saliinger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saliinger/32/77470_2.png) [@Saliinger](https://discuss.elastic.co/u/Saliinger)\
**Post date:** [October 29, 2021, 5:11pm UTC](https://discuss.elastic.co/t/tsvb-table-get-start-date/288025/1 "2021-10-29T17:11:43Z")

</div>

Hello.

I have a TSVB table feeded with heartbeat.  
I'm using the field "summary.down" to watch when uptime goes down. The frequency is 1m and I'm accumulating the time when "summary.down" only shows 1. While that field is in 1, it accumulate the time when it is in.

In the image, it shows "summary.down" goes 1 for 15m.

It seems like that:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/d/5d4ada49758cfb3f5fef4f37934461779cca2804.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/5/45d2c8e113c1b5f53638b644989ea919b1b865b6.png)

I need to put it into a table with 2 columns. The first column only shows the time when "summary.down" goes 1, only the date when that metric starts and the second column need the final value (15m).

Is possible do that?  
Or is there another way to do it?  
I Just want the time when it starts and the interval when "summary.down" goes 1.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [November 1, 2021, 12:57pm UTC](https://discuss.elastic.co/t/tsvb-table-get-start-date/288025/2 "2021-11-01T12:57:27Z")

</div>

I can't think of a way of doing it in TSVB or table vis. It might be possible in Canvas using ESSQL, but I am not 100% sure. You should also try the Uptime app, since you're already using hearbeat as it normally has all the metrics and KPIs for something like this.

---

<div class="post-metadata">

**Author:** ![Saliinger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saliinger/32/77470_2.png) [@Saliinger](https://discuss.elastic.co/u/Saliinger)\
**Post date:** [November 1, 2021, 8:58pm UTC](https://discuss.elastic.co/t/tsvb-table-get-start-date/288025/3 "2021-11-01T20:58:38Z")

</div>

Hello!  
Thanks for your answer. 🙂

I don't think use Canvas could be possible, because I need this data in a dashboard and [Canvas](https://discuss.elastic.co/t/adding-canvas-elements-in-kibana-dashboard/205585) is not " embeddable in dashboards (yet)".

I will try to use the Uptime app and see if it works.

In other hand, If I have this visualization:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/2/d25bed902760288d8f635203eae8d213510332ac.png)

Can I get the interval of this metrics when it goes to 0 and make it a table? (Is for the same propouse than I describe upside)

:cheers:

---

<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:** [November 29, 2021, 8:59pm UTC](https://discuss.elastic.co/t/tsvb-table-get-start-date/288025/4 "2021-11-29T20:59:21Z")

</div>

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