Splunk Search

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

Communicator

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.

Tags (3)
0 Karma
1 Solution

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

View solution in original post

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

View solution in original post

Communicator

Thanks Its really Helpful.

0 Karma

Splunk Employee
Splunk Employee

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

0 Karma

Community Manager
Community Manager

done and upvoted 🙂