I have some JSON data , in that i want to sum all values of a key in a Splunk query. Below is the sample data :
data":[{"abc":"1234","mainrate":12},{"abc":"186","mainrate":222},{"abc":"633","mainrate":121},]}],
Tried using sum
but that is not giving me sum of all minrate. I'm using the below query to get this done :
eventtype=mytest| eventstats sum(mainrate) AS TotalMinRate