How to Add percentage to Column?

[woodlandrelic]

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

Thanks

[gcusello · Accepted solution]

Hi @woodlandrelic,

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]

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]

Hi @woodlandrelic ,

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

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉