Splunk Search

How to use plus sign before a result to calculate percentage?

jip31
Motivator

Hello
I use the eval below in order to calculate a percentage

| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1)." %" 

When Proc_dest is > to Proc_source I have a result with minus - perfect
But when Proc_dest is < to Proc_source, I need to have a + sign before the result
could you help me to do this please?

Tags (2)
0 Karma
1 Solution

nickhills
Ultra Champion

Hi.
Using regex/sed you could try this

...| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1)." %" 
   |rex mode=sed field=Trend_Proc_time "s/^(\d+)/+\1/"
If my comment helps, please give it a thumbs up!

View solution in original post

0 Karma

nickhills
Ultra Champion

Hi.
Using regex/sed you could try this

...| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1)." %" 
   |rex mode=sed field=Trend_Proc_time "s/^(\d+)/+\1/"
If my comment helps, please give it a thumbs up!
0 Karma

jip31
Motivator

perfect thanks

0 Karma

vnravikumar
Champion

Hi

Try like

your query| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1) 
    | eval Trend_Proc_time=if(Trend_Proc_time>0,"+".Trend_Proc_time." %",Trend_Proc_time." %")
0 Karma

jip31
Motivator

sorry it doesnt works

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...