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!