topic Re: Add percentage to Column in Splunk Search

How to Add percentage to Column?

woodlandrelic — Wed, 23 Aug 2023 19:57:13 GMT

Hi
I am trying to add % to the "by percent" column only. I can't seem to get it to show.

Thanks

gcusello — Wed, 23 Aug 2023 16:06:44 GMT

please next time, add to your question also the code in text format (using the Insert/Edit Code Sample button), so we don't have to rewrite the code!

Anyway,, before the table command you should add an eval command like the following

<your_search> | eval HBSS=HBSS."%", ACAS=ACAS."%"

if you want you could also round the results e.f. to the second decimal:

<your_search> | eval HBSS=round(HBSS,2)."%", ACAS=round(ACAS,2)."%"

Ciao.

Giuseppe

woodlandrelic — Wed, 23 Aug 2023 16:47:15 GMT

Hi @gcusello

My apologies, I will do that next time.
This is how I got it to work because I needed to still divide by "dnsName"

| eval HBSS=round(HBSS/dnsName*100)."%"

Thank you

gcusello — Thu, 24 Aug 2023 06:12:59 GMT

good for you, you're always welcome! see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉