Hello ,
I have a table, each line of this table has a specific value, I need a search command to calculate the percentage of each line on the sum of these values .
Any help please ?
Thanks
Hi,
Please try below query, replace <fieldname>
with actual fieldname.
<yourBaseSearch>
| eventstats sum(<fieldname>) as total
| eval percentage=(<fieldname>/total)*100
Hi,
Please try below query, replace <fieldname>
with actual fieldname.
<yourBaseSearch>
| eventstats sum(<fieldname>) as total
| eval percentage=(<fieldname>/total)*100
it's work ! thanks