Hi,
I am looking to filter out the contents of Search results that is using rex, transpose and count.
we are having multiple results with count 0 and need to be removed from report as its occupying majority of dashboard.
Below is Command sample:
table "_raw" | rex field=_raw "(?PCode1)" | rex field=_raw "(?PCode2)" | rex field=_raw " (?PCode3) " | stats count(eval(match(AA,""))) AS "Message1", count(eval(match(AB,".*"))) AS "Message2" , count(eval(match(AC,".*"))) AS "Message3" |transpose
i am not sure how i can filter out this as where count>0 is not working.
... View more