Splunk Search
Highlighted

Use stats to show multiple values resulting from fields generated by eval command

Communicator

Sorry, for some reason I cannot post my code, so attaching photo instead (please post my code if you can).

Result shows "Active Links" which is the distinct count of Link with both PASS and FAIL KPI. I would also want to include distinct count of Link with FAILCOUNT.

Link is a subset of LINKREGION as shown below:

Link LINKREGION
Dallas-Tokyo USA-APAC
LosAngeles-Manila USA-APAC
Boston-Paris USA-EUR
Chicago-Frankfurt USA-EUR
Paris-Frankfurt EUR-EUR

Thank you in advance!

0 Karma
Highlighted

Re: Use stats to show multiple values resulting from fields generated by eval command

SplunkTrust
SplunkTrust

Before Stats, add following eval command

| eval FailLINK=if(KPI="FAIL",LINK,null())

Now add following to your stats

dc(FailLINK) as "Failed Links"

View solution in original post

0 Karma
Highlighted

Re: Use stats to show multiple values resulting from fields generated by eval command

Communicator

That worked (just changed LINK to Link) - thank you!

0 Karma