chart command

[lucky]

HI All,

I need to display the results same as like below 

|chart count over API by StatusCode 

API  200 300 400 400 total
--   ---      ----     --      ---
but I need to display the results behind API more fields like host and method as well

API host method 200 300 400  total 
--     ---    ---              --      ---    ----

please help to get the results

[ITWhisperer]

| eval merged=API."|".host."|".method
| chart count over merged by StatusCode
| addtotals
| eval API=mvindex(split(merged,"|"),0)
| eval host=mvindex(split(merged,"|"),1)
| eval method=mvindex(split(merged,"|"),2)
| fields - merged