create table for each application by each service

[marellasunil]

I am having 5 applications each having service names few are same.
Ex : Application A - Services AA, AB, AC, Application B - Services BA, AB, BC and Application C - Services CA, CB, AC etc..
I want to generate a table for each application, each service. can you please help me to generate table
Application Service Totalcount Responcetime
A AA 10 100.34
A AB 14 2330
A AA 1 334
B AB 15 2130
B AA 14 1034
B AB 34 230
C AA 54 1004
C AB 34 2330
C AA 34 0.34

[Ayn · Accepted solution]

... | stats count as totalcount,avg(responsetime) as responsetime by application,service