Help with Painless Script - Kibana Visualize

Elastic Stack Kibana
1

I am using Metricbeats to monitor my system so I have the logs I need. I want to "Count" all the servers Where the CPU% is over 50%.

In the attached example, I would like to see a count of 2.

My specific question is how to write a calculation that will only show the count of servers with CPU% in the rang I am interested in. Again, a single number.

Snip20180301_13
Snip20180301_13.png1908×772 71.9 KB

2

I think this is close. With the painless script you can return 1 or 0 depending on whether it meets your criteria, and then add a series aggregation below it to combine sum the results.

3

Can you show me? I am looking for a guide to this language, but I haven't found what I needed yet.