Can someone please advise how to add all "pv_estimate" values in the incoming message together and send the sum to the output? Thanks
I am guessing that the objects you have shown are elements of a payload array, as your image leaves alot of info out.
Feed the payload into a change node
set msg.payload
to JSONata J: $sum($$.payload.pv_estimate)
If that fails please present an input object that is copyable.
[
{
"estimated_actuals": [
{
"pv_estimate": 0.766,
"period_end": "2022-10-09T15:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.149,
"period_end": "2022-10-09T15:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.49,
"period_end": "2022-10-09T14:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.78,
"period_end": "2022-10-09T14:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.018,
"period_end": "2022-10-09T13:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.199,
"period_end": "2022-10-09T13:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.029,
"period_end": "2022-10-09T12:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.624,
"period_end": "2022-10-09T12:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.237,
"period_end": "2022-10-09T11:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.482,
"period_end": "2022-10-09T11:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.461,
"period_end": "2022-10-09T10:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.372,
"period_end": "2022-10-09T10:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.229,
"period_end": "2022-10-09T09:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.037,
"period_end": "2022-10-09T09:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.799,
"period_end": "2022-10-09T08:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.516,
"period_end": "2022-10-09T08:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.192,
"period_end": "2022-10-09T07:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.843,
"period_end": "2022-10-09T07:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.488,
"period_end": "2022-10-09T06:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.159,
"period_end": "2022-10-09T06:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T16:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.089,
"period_end": "2022-10-08T16:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.382,
"period_end": "2022-10-08T15:30:00.0000000Z",
"period": "PT30M"
}
]
},
{
"estimated_actuals": [
{
"pv_estimate": 0.766,
"period_end": "2022-10-09T15:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.149,
"period_end": "2022-10-09T15:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.49,
"period_end": "2022-10-09T14:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.78,
"period_end": "2022-10-09T14:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.018,
"period_end": "2022-10-09T13:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.199,
"period_end": "2022-10-09T13:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.029,
"period_end": "2022-10-09T12:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.624,
"period_end": "2022-10-09T12:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.237,
"period_end": "2022-10-09T11:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.482,
"period_end": "2022-10-09T11:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.461,
"period_end": "2022-10-09T10:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.372,
"period_end": "2022-10-09T10:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.229,
"period_end": "2022-10-09T09:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.037,
"period_end": "2022-10-09T09:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.799,
"period_end": "2022-10-09T08:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.516,
"period_end": "2022-10-09T08:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.192,
"period_end": "2022-10-09T07:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.843,
"period_end": "2022-10-09T07:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.488,
"period_end": "2022-10-09T06:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.159,
"period_end": "2022-10-09T06:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T16:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.089,
"period_end": "2022-10-08T16:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.382,
"period_end": "2022-10-08T15:30:00.0000000Z",
"period": "PT30M"
}
]
},
{
"estimated_actuals": [
{
"pv_estimate": 0.766,
"period_end": "2022-10-09T15:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.149,
"period_end": "2022-10-09T15:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.49,
"period_end": "2022-10-09T14:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.78,
"period_end": "2022-10-09T14:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.018,
"period_end": "2022-10-09T13:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.199,
"period_end": "2022-10-09T13:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.029,
"period_end": "2022-10-09T12:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.624,
"period_end": "2022-10-09T12:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.237,
"period_end": "2022-10-09T11:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.482,
"period_end": "2022-10-09T11:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.461,
"period_end": "2022-10-09T10:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.372,
"period_end": "2022-10-09T10:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.229,
"period_end": "2022-10-09T09:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.037,
"period_end": "2022-10-09T09:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.799,
"period_end": "2022-10-09T08:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.516,
"period_end": "2022-10-09T08:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.192,
"period_end": "2022-10-09T07:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.843,
"period_end": "2022-10-09T07:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.488,
"period_end": "2022-10-09T06:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.159,
"period_end": "2022-10-09T06:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T16:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.089,
"period_end": "2022-10-08T16:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.382,
"period_end": "2022-10-08T15:30:00.0000000Z",
"period": "PT30M"
}
]
},
{
"estimated_actuals": [
{
"pv_estimate": 0.766,
"period_end": "2022-10-09T15:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.149,
"period_end": "2022-10-09T15:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.49,
"period_end": "2022-10-09T14:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.78,
"period_end": "2022-10-09T14:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.018,
"period_end": "2022-10-09T13:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.199,
"period_end": "2022-10-09T13:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.029,
"period_end": "2022-10-09T12:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.624,
"period_end": "2022-10-09T12:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.237,
"period_end": "2022-10-09T11:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.482,
"period_end": "2022-10-09T11:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.461,
"period_end": "2022-10-09T10:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.372,
"period_end": "2022-10-09T10:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.229,
"period_end": "2022-10-09T09:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 2.037,
"period_end": "2022-10-09T09:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.799,
"period_end": "2022-10-09T08:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.516,
"period_end": "2022-10-09T08:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 1.192,
"period_end": "2022-10-09T07:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.843,
"period_end": "2022-10-09T07:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.488,
"period_end": "2022-10-09T06:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.159,
"period_end": "2022-10-09T06:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T05:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T04:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T03:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T02:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T01:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-09T00:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T23:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T22:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T21:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T20:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T19:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T18:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T17:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0,
"period_end": "2022-10-08T16:30:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.089,
"period_end": "2022-10-08T16:00:00.0000000Z",
"period": "PT30M"
},
{
"pv_estimate": 0.382,
"period_end": "2022-10-08T15:30:00.0000000Z",
"period": "PT30M"
}
]
}
]
I am still guessing that that info is in payload
$sum($$.payload[0].estimated_actuals.pv_estimate)
Please show image of debug showing full msg object, if this did not work.
Yes, but "estimated" array is four times, and each have 48 "pv_estimate" records.
$sum($$.payload[0].estimated_actuals.pv_estimate) works for only first
[{"estimated_actuals":[{"pv_estimate":0.766,"period_end":"2022-10-09T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.149,"period_end":"2022-10-09T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.49,"period_end":"2022-10-09T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.78,"period_end":"2022-10-09T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.018,"period_end":"2022-10-09T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.199,"period_end":"2022-10-09T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.029,"period_end":"2022-10-09T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.624,"period_end":"2022-10-09T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.237,"period_end":"2022-10-09T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.482,"period_end":"2022-10-09T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.461,"period_end":"2022-10-09T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.372,"period_end":"2022-10-09T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.229,"period_end":"2022-10-09T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.037,"period_end":"2022-10-09T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.799,"period_end":"2022-10-09T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.516,"period_end":"2022-10-09T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.192,"period_end":"2022-10-09T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.843,"period_end":"2022-10-09T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.488,"period_end":"2022-10-09T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.159,"period_end":"2022-10-09T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.089,"period_end":"2022-10-08T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.382,"period_end":"2022-10-08T15:30:00.0000000Z","period":"PT30M"}]},{"estimated_actuals":[{"pv_estimate":0.766,"period_end":"2022-10-09T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.149,"period_end":"2022-10-09T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.49,"period_end":"2022-10-09T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.78,"period_end":"2022-10-09T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.018,"period_end":"2022-10-09T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.199,"period_end":"2022-10-09T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.029,"period_end":"2022-10-09T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.624,"period_end":"2022-10-09T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.237,"period_end":"2022-10-09T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.482,"period_end":"2022-10-09T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.461,"period_end":"2022-10-09T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.372,"period_end":"2022-10-09T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.229,"period_end":"2022-10-09T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.037,"period_end":"2022-10-09T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.799,"period_end":"2022-10-09T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.516,"period_end":"2022-10-09T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.192,"period_end":"2022-10-09T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.843,"period_end":"2022-10-09T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.488,"period_end":"2022-10-09T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.159,"period_end":"2022-10-09T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.089,"period_end":"2022-10-08T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.382,"period_end":"2022-10-08T15:30:00.0000000Z","period":"PT30M"}]},{"estimated_actuals":[{"pv_estimate":0.766,"period_end":"2022-10-09T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.149,"period_end":"2022-10-09T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.49,"period_end":"2022-10-09T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.78,"period_end":"2022-10-09T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.018,"period_end":"2022-10-09T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.199,"period_end":"2022-10-09T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.029,"period_end":"2022-10-09T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.624,"period_end":"2022-10-09T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.237,"period_end":"2022-10-09T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.482,"period_end":"2022-10-09T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.461,"period_end":"2022-10-09T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.372,"period_end":"2022-10-09T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.229,"period_end":"2022-10-09T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.037,"period_end":"2022-10-09T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.799,"period_end":"2022-10-09T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.516,"period_end":"2022-10-09T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.192,"period_end":"2022-10-09T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.843,"period_end":"2022-10-09T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.488,"period_end":"2022-10-09T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.159,"period_end":"2022-10-09T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.089,"period_end":"2022-10-08T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.382,"period_end":"2022-10-08T15:30:00.0000000Z","period":"PT30M"}]},{"estimated_actuals":[{"pv_estimate":0.766,"period_end":"2022-10-09T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.149,"period_end":"2022-10-09T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.49,"period_end":"2022-10-09T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.78,"period_end":"2022-10-09T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.018,"period_end":"2022-10-09T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.199,"period_end":"2022-10-09T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.029,"period_end":"2022-10-09T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.624,"period_end":"2022-10-09T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.237,"period_end":"2022-10-09T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.482,"period_end":"2022-10-09T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.461,"period_end":"2022-10-09T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.372,"period_end":"2022-10-09T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.229,"period_end":"2022-10-09T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.037,"period_end":"2022-10-09T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.799,"period_end":"2022-10-09T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.516,"period_end":"2022-10-09T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.192,"period_end":"2022-10-09T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.843,"period_end":"2022-10-09T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.488,"period_end":"2022-10-09T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.159,"period_end":"2022-10-09T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-09T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"period_end":"2022-10-08T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.089,"period_end":"2022-10-08T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.382,"period_end":"2022-10-08T15:30:00.0000000Z","period":"PT30M"}]}]
I saw your image as one array. Then your copyable object was so large i did not see the 4 arrays. Maybe next time cut it down to 3 objects per array element for testing.
Anyway
For 4 separate array results $$.payload.$sum($.estimated_actuals.pv_estimate)
For the total of all $sum($$.payload[*].estimated_actuals.pv_estimate)
1 Like
It works! Thank you for saving lot of my time.
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
