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 {id,methodname,timetaken} 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.
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.
Thanks!
