index=tibco TerweeAdapter (GPS OR NIAS)| rex field=_raw "ConversationID=(?.*)" | eval n=substr(bericht,1,3) | eval code=case(n="GPS","GPS",n="NIA","NIAS",0=0,"OVERIG") | chart count by code
code count
GPS 76
NIAS 12
index=tibco TerweeAdapter (GPS OR NIAS)| rex field=_raw "ConversationID=(? .*)" | eval n=substr(bericht,1,3) | eval code=case(n="GPS","GPS",n="NIA","NIAS",0=0,"OVERIG") | stats count by code
code count
GPS 76
NIAS 12
Same result... still the last variable is missing for some reason
ConversationID=(? .*) is weird btw because its missing the word "bericht" between "<" and ">" which is in my string of course
... View more