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:
Thank you in advance!
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
That worked (just changed LINK to Link) - thank you!