Friends,
I have extracted the field "ussdcode" from xml using "xmlkv" and renamed it to "UssdCode" . Now I want to pass value to "UssdCode" using dropdown list. I have also created "UssdCode_Token" in dropdown and have provided static value "ALL =* " in dropdown.
can someone plz help me with filtering the data using dropdown?
index=masapi sourcetype = myaccountservices-api_reporting_log ussdcode
AND StatusCode=$StatusCode_token$
|eval temp=split(_raw,":")
|eval trx_id=mvindex(temp,3)
|dedup trx_id
|xmlkv
|rename ussdcode as UssdCode
|stats Count by UssdCode,StatusCode
| addcoltotals Count labelfield="StatusCode"