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.