Scripted field with division does not show result

[LeeDr (Lee Drengenberg)]

I would suggest the Visual Builder visualization.

Here's one post where we do a ration based on a filter;

Doing Math over count of events

Here's one option if you're on a recent version of Kibana that has the Visual Builder visualization type. I know it's in 5.4.0 and later. go to the Panel Options tab and set your index pattern (here I'm using metricbeat-*); [image] back on the Data tab select Filter Ratio [image] I picked metricset.name:process as my numerator, but yours would be something like transactionStatus:Success [image] The Gauge tab shows a single value and there some options to format as a percent, change…

But you need to sum specific values, so I think you need to do it a little different. This post uses the calculation aggregation;

How to add 2 metrics visualization?

If you are using 5.4 you can achieve this with the Time Series Visual Builder. https://www.elastic.co/guide/en/kibana/current/_featured_visualizations.html You can do many calculations on aggregations. For example, here is a comparison of average bytes calculated automatically vs manually: automatically: [image] Running the calculations manually: [image]

Let me know if this works for you.

Regards,
Lee