Solved: How to Add percentage to Column?

woodlandrelic · ‎08-23-2023

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

Thanks

gcusello · ‎08-23-2023

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

gcusello · ‎08-23-2023

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 · ‎08-23-2023

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 · ‎08-23-2023

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

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉

How to Add percentage to Column?