I have been struggling to find a visualization solution that fits my company's needs. I do not only need to visualize time series data but also need to be able to do calculations "vertically" across all the data at one point of time (averages/ratios) as well as "horizontally" across different points of time if possible (see my question here trying to achieve this with kibana).

Displaying averages in Grafana for example is no problem, but I already struggle when it comes to calculating a ratio of the kind (successful runs/all runs) because when using the lucene syntax to query elasticsearch there is no option to use calculations..

I am open to any visualization solution that could accomplish this, grafana, kibana, banana, I dont care as long as it works.. Thanks for the help.

Edit: To give a usecase without you having to click the link: I need to calculate the mean time between failures for jenkins pipelines. So the time between one build with result: "FAILURE" to the next one with a different ID with the result == "FAILURE".

Cheers,

Tobias