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!
Before Stats, add following eval command
| eval FailLINK=if(KPI="FAIL",LINK,null())
Now add following to your stats
dc(FailLINK) as "Failed Links"
Before Stats, add following eval command
| eval FailLINK=if(KPI="FAIL",LINK,null())
Now add following to your stats
dc(FailLINK) as "Failed Links"
That worked (just changed LINK to Link) - thank you!