https://community.splunk.com/t5/Reporting/filter-pivot-table-result/m-p/367229#M6326 <P>I'm trying to capture my api performace by using logs created by different components in 1 particular request. My different components are logging time taken as <CODE>{id,methodname,timetaken}</CODE> where methodname can be parent method or child method. I'm able to create a pivot table with id as row, methodname as column and sum of time taken as cell value.<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/4850i08C3E3724DE30408/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span><BR /> so far so good but now I want average of time taken by Parent methods along with average of child methods. How can I get these numbers from data I have.</P> <P>Thanks!</P> Sat, 28 Apr 2018 00:05:00 GMT rjaimini 2018-04-28T00:05:00Z https://community.splunk.com/t5/Reporting/filter-pivot-table-result/m-p/367229#M6326 <P>I'm trying to capture my api performace by using logs created by different components in 1 particular request. My different components are logging time taken as <CODE>{id,methodname,timetaken}</CODE> where methodname can be parent method or child method. I'm able to create a pivot table with id as row, methodname as column and sum of time taken as cell value.<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/4850i08C3E3724DE30408/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span><BR /> so far so good but now I want average of time taken by Parent methods along with average of child methods. How can I get these numbers from data I have.</P> <P>Thanks!</P> Sat, 28 Apr 2018 00:05:00 GMT https://community.splunk.com/t5/Reporting/filter-pivot-table-result/m-p/367229#M6326 rjaimini 2018-04-28T00:05:00Z