topic How do I add the values in a single row and three columns? in Splunk Search

How do I add the values in a single row and three columns?

Bala — Fri, 11 Mar 2022 15:43:12 GMT

stats count(eval(searchmatch(Bala))) as A count(eval(searchmatch(kasa))) as B count(eval(searchmatch(reddy))) as C

A	B	C
1	2	3

now i want the total of these row values as single table

Total

venky1544 — Fri, 11 Mar 2022 14:27:11 GMT

use

| addtotals |fields -A,B,C it should give you total 6

Bala — Fri, 11 Mar 2022 14:24:21 GMT

| addtotals

will give the results by adding one more column at the table like below

A	B	C	Total
1	2	3	6

but i want it as single table , i want to dispaly the total as below

Total

Bala — Fri, 11 Mar 2022 15:23:32 GMT

Yes, i got the result now i want to rename the total as Failure

venky1544 — Fri, 11 Mar 2022 15:24:58 GMT

FYI

Bala — Fri, 11 Mar 2022 15:33:32 GMT

Yes, i got the result now i want to rename the total as Failure

And also what if i want to add only the B & C column values and A keep remain same.

A	B	C
1	2	3

Result should be

A	Total (rename it as count)
1	5

venky1544 — Fri, 11 Mar 2022 15:39:10 GMT

Just use the rename command should work

| addtotals |fields - A,B,C |rename Total as Failure

Note : PLease accept the solution if the reply worked for you it might help others as well

Bala — Fri, 11 Mar 2022 15:46:38 GMT

Yes, i got the result now i want to rename the total as Failure

And also what if i want to add only the B & C column values and A keep remain same.

A	B	C
1	2	3

Result should be

A	Total (rename it as count)
1	5

venky1544 — Fri, 11 Mar 2022 15:59:40 GMT