https://community.splunk.com/t5/Splunk-Search/create-table-for-each-application-by-each-service/m-p/93063#M23976 <PRE><CODE>... | stats count as totalcount,avg(responsetime) as responsetime by application,service </CODE></PRE> Sun, 14 Apr 2013 06:48:20 GMT Ayn 2013-04-14T06:48:20Z https://community.splunk.com/t5/Splunk-Search/create-table-for-each-application-by-each-service/m-p/93062#M23975 <P>I am having 5 applications each having service names few are same.<BR /> Ex : Application A - Services AA, AB, AC, Application B - Services BA, AB, BC and Application C - Services CA, CB, AC etc..<BR /> I want to generate a table for each application, each service. can you please help me to generate table <BR /> Application Service Totalcount Responcetime<BR /> A AA 10 100.34<BR /> A AB 14 2330<BR /> A AA 1 334<BR /> B AB 15 2130<BR /> B AA 14 1034<BR /> B AB 34 230<BR /> C AA 54 1004<BR /> C AB 34 2330<BR /> C AA 34 0.34</P> Sun, 14 Apr 2013 01:17:42 GMT https://community.splunk.com/t5/Splunk-Search/create-table-for-each-application-by-each-service/m-p/93062#M23975 marellasunil 2013-04-14T01:17:42Z https://community.splunk.com/t5/Splunk-Search/create-table-for-each-application-by-each-service/m-p/93063#M23976 <PRE><CODE>... | stats count as totalcount,avg(responsetime) as responsetime by application,service </CODE></PRE> Sun, 14 Apr 2013 06:48:20 GMT https://community.splunk.com/t5/Splunk-Search/create-table-for-each-application-by-each-service/m-p/93063#M23976 Ayn 2013-04-14T06:48:20Z