How to integrate user-specified Kibana fields with my data fields

Here is a basic case I am trying to solve. The data provides events that indicate how long a device lost cellular connectivity. I can use Kibana to get the total amount of downtime. However, the downtime is in seconds and the total was calculated over a Kibana-specified time interval, say year to date.

I would like to display in a histogram the number of events versus the length of the downtime which I can do. But what is displayed is in seconds. How can I get Kibana to display the downtime values in minutes or hours? Something more digestible to the reader.

I would also like to display a plot which would give the total downtime/total time per device. I can do the total downtime per device, but the total time is given by the user's selection of the time range. It is not in my data.

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