Splunk Search

Calculate sum of duration for Sub calls

rajkskumar
Explorer

I have data in the following structure received for every event. Some events have just one or two sub calls and some have more sub calls. I need to calculate the sum of the total duration.

 

 

 

subCalls: [ [-]
         { [-]
           completionTimeMs: 69
           method: GET
           statusCode: 200
         }
         { [-]
           completionTimeMs: 77
           method: GET
           statusCode: 200
         }
         { [-]
           completionTimeMs: 956
           method: POST
           statusCode: 200
         }
         { [-]
           completionTimeMs: 201
           method: PATCH
           statusCode: 204
         }
       ]

 

 

 

The below search calculates the sum of all the values in all the events instead of every event. Please suggest on how to proceed further.

 

 

 

mysearch
| eventstats sum(processRelevantFields.eventDetails.subCalls{}.completionTimeMs) as totalDuration
| table traceId, totalDuration

 

 

 

 

 

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...