How do I write a search to get a table of metrics to show the count of different Markets by Site?

[rameshlpatel]

Hi,

I have a requirement where I want to display a metrics table. Vertically, I want to show different sites like (1,2,3, 4 etc) and horizontally, I want to show different markets (Residential, Commercial etc) So I want to show site & market vise count.

Site Commercial Residential
1 10 24
2 23 34
3 24 54

How can I write a search to achieve that?

In my events, I have Site detail and market detail information.

[aljohnson_splun · Accepted solution]

... | chart sum(Commericial) as CommericalSum, sum(Residential) as ResidentialSum by Site

[rameshlpatel]

Thanks Its really Helpful.

[aljohnson_splun]

Can you mark the answer as accepted ? Otherwise this is left as an "unanswered question".

[ppablo]

done and upvoted 🙂