topic Need help to get total count in Knowledge Management

Need help to get total count

vishwa — Sat, 13 Apr 2024 01:52:01 GMT

OUTPUT:

RampdataSet	Initial message received with below details	Letter published correctley to ATM subject	Letter published correctley to DMM subject	Letter rejected due to: DOUBLE_KEY	Letter rejected due to: UNVALID_LOG	Letter rejected due to: UNVALID_DATA_APP
WAC	10	0	0	10	0	10
WAX	30	15	15	60	15	60
WAM	22	20	20	62	20	62
STC	33	12	12	57	12	57
STX	66	30	0	96	0	96
OTP	20	10	0	30	0	30
TTC	0	5	0	5	0	5
TAN	0	7	0	7	0	7

But we want output as shown below:
Total="Letter published correctley to ATM subject" + "Letter published correctley to DMM subject" + "Letter published correctley to DMM subject" + "Letter rejected due to: DOUBLE_KEY" + "Letter rejected due to: UNVALID_LOG" + "Letter rejected due to: UNVALID_DATA_APP"

|table "Initial message received with below details" Total

RampdataSet	Initial message received with below details	Total
WAC	10	20
WAX	30	165
WAM	22	184
STC	33	150
STX	66	222
OTP	20	70
TTC	0	15
TAN	0	21

Re: Need help to get total count

gcusello — Sat, 13 Apr 2024 05:17:54 GMT

Hi @vishwa

you can use eval (https://docs.splunk.com/Documentation/SCS/current/SearchReference/EvalCommandOverview) or addtotal (https://docs.splunk.com/Documentation/Splunk/9.2.1/SearchReference/Addtotals), something like this:

index=app-index source=application.logs | rex field= _raw "RampData :\s(?<RampdataSet>\w+)" | rex field= _raw "(?<Message>Initial message received with below details|Letter published correctley to ATM subject|Letter published correctley to DMM subject|Letter rejected due to: DOUBLE_KEY|Letter rejected due to: UNVALID_LOG|Letter rejected due to: UNVALID_DATA_APP)" | chart count over RampdataSet by Message | eval Total="Letter published correctley to ATM subject" + "Letter published correctley to DMM subject" + "Letter published correctley to DMM subject" + "Letter rejected due to: DOUBLE_KEY" + "Letter rejected due to: UNVALID_LOG" + "Letter rejected due to: UNVALID_DATA_APP" | table "Initial message received with below details" Total

Ciao.

Giuseppe

Re: Need help to get total count

vishwa — Sat, 13 Apr 2024 18:09:03 GMT

Hi @gcusello We tried the query you provided eval command, but it not working output is:

RampdataSet	Initial message received with below details	Total
WAC	10	Letter published correctley to ATM subject
WAX	30	Letter published correctley to DMM subject
WAM	22	Letter rejected due to: DOUBLE_KEY
STC	33	Letter rejected due to: UNVALID_LOG
STX	66	Letter rejected due to: UNVALID_DATA_APP

We tried addtotals as well, pls see the output:

RampdataSet	Initial message received with below details	Total
WAC		20
WAX		165
WAM		184
STC		150
STX		222
OTP		70
TTC		15
TAN		21

Re: Need help to get total count

gcusello — Sun, 14 Apr 2024 05:21:54 GMT

Hi @vishwa ,

if you run your search, have you the table you shared?

if yes, using the eval I hinted you sum the values ot the columns in the Total value.

You could also use addtotals command that sums all the values for each row:

But also in this case que question is: does your search extract the value for each column?

Ciao.

Giuseppe