Feedback
Got feedback? We want it! Submit your comments and suggestions for our community here.

show percentage

ELADMIN
Engager

Hi, I would like to fix this alert to show the results in the value columm as a double digit percentage and have the percent sign after the number. for example  27%.  Thank you in advance for your help. 

MY SPL

index=perfmon object=Memory "% Committed Bytes In Use"
| where Value < 25
| table _time, host, Value, date
| dedup host

 

My Result. 

ELADMIN_0-1702390069307.png

 

0 Karma
1 Solution

dtburrows3
Builder

Performing this eval anytime after the where clause should do it.

index=perfmon object=Memory "% Committed Bytes In Use"
    | where Value < 25
    | table _time, host, Value, date
    | dedup host
    | eval Value=round(Value, 0)."%"



View solution in original post

dtburrows3
Builder

Performing this eval anytime after the where clause should do it.

index=perfmon object=Memory "% Committed Bytes In Use"
    | where Value < 25
    | table _time, host, Value, date
    | dedup host
    | eval Value=round(Value, 0)."%"



ELADMIN
Engager

Yes, that works. thank you dtburrows3.

0 Karma
Get Updates on the Splunk Community!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...