topic Re: Calculate completion% for a specific field in a table and display it under the same field in Dashboards & Visualizations

Calculate completion% for a specific field in a table and display it under the same field

maverick27 — Wed, 06 Dec 2023 08:43:30 GMT

I need your expertise in solving a rather simple issue which is taking lot more hours for me to solve. I'm trying to create a table in Splunk which should display Grand Total under each row and also display Compleion% under "Completed" field. I'm able to achieve the grand total using addcoltotals. However, I'm unable to display the completion% under "Completed" field.

Here is how the table should look like:

Name	Remaining	Completed
Alice	25	18
Bob	63	42
Claire	10	7
David	45	30
Emma	80	65
Grand Total:	223	162
Completion%		42.07%

percetnage calculation = 162/(223+162)*100

I tried using eval function to calculate the percentage but it calculates for each row in a new field. Can you please help me out? Many thanks. Much appreciated!

Re: Calculate completion% for a specific field in a table and display it under the same field

ITWhisperer — Wed, 06 Dec 2023 08:58:06 GMT

Re: Calculate completion% for a specific field in a table and display it under the same field

maverick27 — Wed, 06 Dec 2023 09:49:04 GMT

@ITWhisperer Thank you for the quick revert. It worked! 🙂