Trouble visualizing CPU utilization

[Matty (Mickster)]

I am using metricbeat to visualize system and network performance across my fleet. It works great! One thing I' having a hard time with is getting CPU used vs. CPU idle. I would like to be able to subtract system.cpu.idle.pct
from 100 to get the current utilization. The following forum post suggested using scripted fields:

Metricbeat CPU usage total

Hiya, Metricbeat is working nicely for me but what I want to see for my servers are how busy they are. I get the CPU usage in parts (user, system, steal etc) and the idle %, what I want is the total usage as a percentage; the opposite of the idle percent value. I expect the answer might be a TimeLion based one but I can't get that to work. Is there a really good TimeLion tutorial out there? My solution in the end was to use logstash and a bit of ruby in the filter section like this: if [@me…

I created a scripted field with the following attributes:

Index -> metricbeat-*
Name -> cpuutilization
Language -> expression
Type: number
Format -> default
Script -> 100 - doc['system.cpu.idle.pct'].value

And used the following video as a starting point:

Using Painless in Kibana scripted fields

My field isn't showing up under discover and refreshing the fields doesn't appear to help. First off, is this the ideal way to get actual utilization? Second, any idea why the cpuutilization field isn't showing up?

[Matty (Mickster)]

I solved by own problem. The system.cpu.* values returned by metricbeat are percentages so I needed to set format to a percentage. Now my graphs are rendering correctly.