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.