Given a series incoming events like say:
I need to perform some calculation which would be of the form
(max (a) - min (a) )* (max (b) - min (b)) / (max (c) - min (c) ).
Thanks to this. I know how to show it as a time series graph (using Visual Builder). But I also want to show it as a simple number for the overall duration that has been selected.
I tried lucene expression numeric APIs (doc['field_name'].max(), min()) but that doesn't work. I didn't see any such API within painless.
I also looked at "Scripted Metric Aggregation", but couldn't quite understand, where in Kibana to specify those expressions.
Same is the case with "Metrics Aggregation", how do I make use of it within Kibana?
It's driving me nuts that how can displaying aggregated number be so difficult as compared to a time-series chart? Any help in this matter is highly appreciated. Thanks.