# Show time left using goal widget

**URL:** <https://discuss.elastic.co/t/show-time-left-using-goal-widget/142968>\
**Category:** Kibana\
**Created:** [August 3, 2018, 8:10pm UTC](https://discuss.elastic.co/t/show-time-left-using-goal-widget/142968 "2018-08-03T20:10:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![d\_s](https://avatars.discourse-cdn.com/v4/letter/d/2bfe46/32.png) [@d\_s](https://discuss.elastic.co/u/d_s)\
**Post date:** [August 3, 2018, 8:10pm UTC](https://discuss.elastic.co/t/show-time-left-using-goal-widget/142968/1 "2018-08-03T20:10:29Z")

</div>

**EDIT: Sorry it looks like I misunderstood what I needed to do. I managed to resolve my issues.**

Hello!  
I am trying to use the goal widget to show the amount of time left until something expires. For example, if I have an item that lasts 200 hours then I want to look at the first timestamp and latest timestamp and then calculate how much time has elapsed in between and use the goal widget to show that. I have data for multiple items all in one table so I first need to find the first and latest timestamp for a particular item and then calculate the amount of time that has been elapsed.

Is there any way to do this in Kibana?  
Thank you!

---

<div class="post-metadata">

**Author:** ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)\
**Post date:** [August 6, 2018, 12:32pm UTC](https://discuss.elastic.co/t/show-time-left-using-goal-widget/142968/2 "2018-08-06T12:32:19Z")

</div>

Glad you got things worked out. If you could post your solution here that would be really helpful, as I'm sure others might have the same question.

---

<div class="post-metadata">

**Author:** ![d\_s](https://avatars.discourse-cdn.com/v4/letter/d/2bfe46/32.png) [@d\_s](https://discuss.elastic.co/u/d_s)\
**Post date:** [August 6, 2018, 10:21pm UTC](https://discuss.elastic.co/t/show-time-left-using-goal-widget/142968/3 "2018-08-06T22:21:18Z")

</div>

I didn't exactly find a solution. I just figured out that my data already contained a column where the amount of time that had elapsed was being collected and realized that that column was what I needed to use.

---

<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 3, 2018, 10:21pm UTC](https://discuss.elastic.co/t/show-time-left-using-goal-widget/142968/4 "2018-09-03T22:21:27Z")

</div>

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