How to do Calculation in Elasticsearch Query

[stephenb (Stephen Brown)]

You know Uptime/ Heartbeat does all that for you...cert check and alert.

But yes you can create a runtime field to calculate the difference assuming you are on a fairly recent version.

I had a post on that let me look

Perhaps this will help

Calculate elapsed time in Kibana?

Hi @TXBigDawg1836 Welcome to the community Yup add a runtime field to the Data View here is the code long datenow = new Date().getTime(); long datewas = doc['@timestamp'].value.getMillis(); emit (datenow - datewas); Create / Set the Field [Screen Shot 2022-10-13 at 1.23.42 PM] Chose your format.... [Screen Shot 2022-10-13 at 1.23.54 PM] In Discover [Screen Shot 2022-10-13 at 1.34.19 PM] Now Table... [Screen Shot 2022-10-13 at 1.26.49 PM]