Avg KPI: To get average of array object property

 {"payload":[

{"name": "product1", "price": 100},
{"name": "product2", "price": 25},
{"name": "product1", "price": 50},
{"name": "product2", "price": 75},
{"name": "product3", "price": 25}
]}
payload{name:$average(price)} ~> $each(function($v, $n) {{
'name': $n,
'avg': $v
}}) ^(avg) //this is for ascending/descending order


No comments:

Post a Comment

calling outside object property or parent

 https://try.jsonata.org/dxPC5s-zM { "list1" : [ { "b" : 1 , "list2" : [ { ...