Dashboards & Visualizations

How to create a dashboard with avg cpu usage over 30 days, per host

bond77s
Explorer

 Im currently using the query to find the cpu utilization for a few host but i want to see the average utilization per host 

tag=name "CPU Utilization" | timechart span=15m max(SysStatsUtilizationCpu) by host limit=0

 

Any information would be helpful

Labels (1)
0 Karma

bond77s
Explorer

It worked,  how do i remove the decimal (floating number)

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval average=floor(average)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| timechart span=15m max(SysStatsUtilizationCpu) by host limit=0
| untable _time host SysStatsUtilizationCpu
| stats avg(SysStatsUtilizationCpu) as average by host
0 Karma

bond77s
Explorer

Thank you

0 Karma
Get Updates on the Splunk Community!

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...

Data Management Digest – November 2025

  Welcome to the inaugural edition of Data Management Digest! As your trusted partner in data innovation, the ...