Database
[{"_id":ObjectId("5e48824e7f8bc30a751ee7f4"),"meter_id":"jhk","activePower":{"unit":"kwh","ActivePowerL1":"0","ActivePowerL2":"0","ActivePowerL3":"0","TotalActivePower":"5"},"reactivePower":{},"apparentPower":{},"frequency":{},"thd":{}},{"_id":ObjectId("5e48825a7f8bc30a751ee8f3"),"meter_id":"jhk","activePower":{"unit":"kwh","ActivePowerL1":"0","ActivePowerL2":"0","ActivePowerL3":"0","TotalActivePower":"09"},"reactivePower":{},"apparentPower":{},"frequency":{},"thd":{}},{"_id":ObjectId("5e4882607f8bc30a751ee99f"),"meter_id":"abc","activePower":{"unit":"kwh","ActivePowerL1":"0","ActivePowerL2":"0","ActivePowerL3":"0","TotalActivePower":"5"},"reactivePower":{},"apparentPower":{},"frequency":{},"thd":{}},{"_id":ObjectId("5e48827a7f8bc30a751eeb84"),"meter_id":"lol","activePower":{"unit":"kwh","ActivePowerL1":"0","ActivePowerL2":"0","ActivePowerL3":"0","TotalActivePower":"5"},"reactivePower":{},"apparentPower":{},"frequency":{},"thd":{}}]
Query
db.collection.aggregate([{$group:{_id:"$meter_id",total:{$sum:{$toInt:"$activePower.TotalActivePower"}}}}])