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

[christopheryu]

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!

[somesoni2 · Accepted solution]

Before Stats, add following eval command

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

Now add following to your stats

dc(FailLINK) as "Failed Links"

[christopheryu]

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