How to get sum of specific keys values from array of object

Question

I have similar to the following array of objects:

let violation = [
 {
    "timestamp": 1637658787661,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateHarshAccelerationEvent",
    "value": 71,
 },
 {
    "timestamp": 1637658789678,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateHarshDecelerationEvent",
    "value": 50,
 },
 {
    "timestamp": 1637659776571,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateIdlingEvent",
    "value": 0,
 },
 {
    "timestamp": 1637660707375,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateSpeedingEvent",
    "value": 67,
 },
 {
    "timestamp": 1637661519707,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateHarshAccelerationEvent",
    "value": 71,
 },
 {
    "timestamp": 1637661521773,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateHarshDecelerationEvent",
    "value": 50,
 },
 {
    "timestamp": 1637661548282,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateSpeedingEvent",
    "value": 62,
 },
 {
    "timestamp": 1637663230199,
    "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
    "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
    "message": "CreateSpeedingEvent",
    "value": 66,
 },
 .....
 .....  
]

So here, Each of the object will have a message property or Key of one of four values namely CreateHarshAccelerationEvent, CreateHarshDecelerationEvent, CreateSpeedingEvent, CreateIdlingEvent.

Here I need to get the total of each key. i.e. total of CreateHarshAccelerationEvent and total of CreateHarshDecelerationEvent and total of CreateIdlingEvent and total of CreateSpeedingEvent

But the condition I have to select the object for total with the identifier, and that identifier is the combination of ID of driver and company i.e. key = company + "/" + driver

I am doing the following code for this

    var violations = []

    for (let violation of data){
        var key
        if ( (violation.company) && (violation.driver) ) {

            key = violation.company + "/" + violation.driver;

            let violationType = violation.message; 

            violations[key].company = violation.company;
            violations[key].driver = violation.driver;
            
        }

    }

    console.log(violations);

I need result as

[{
   "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7",
   "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5",
   "CreateHarshAccelerationEvent": "total number of values CreateHarshAccelerationEvent from Array of objects basis on the basis of that custom key i.e. company/driver value",
   "CreateHarshDecelerationEvent": "total number of values CreateHarshDecelerationEvent from Array of objects basis on the basis of that custom key i.e. company/driver value",
   "CreateIdlingEvent": "total number of values CreateIdlingEvent from Array of objects basis on the basis of that custom key i.e. company/driver value",
   "CreateSpeedingEvent": "total number of values CreateSpeedingEvent from Array of objects basis on the basis of that custom key i.e. company/driver value", 
}]

What exactly is your question here? What's not working? Or are you just looking for other approaches? — Endzeit
– Endzeit, Commented Nov 24, 2021 at 11:22
I need to get the total of CreateHarshAccelerationEvent, CreateHarshDecelerationEvent, CreateSpeedingEvent, CreateIdlingEvent as per custom unique identifier in the object result. I have updated the question — Deep Kakkar
– Deep Kakkar, Commented Nov 24, 2021 at 11:24

Nitheesh · Accepted Answer · 2021-11-24 11:33:39Z

Array.reduce will help you.

let violation = [ { "timestamp": 1637658787661, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateHarshAccelerationEvent", "value": 71, }, { "timestamp": 1637658789678, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateHarshDecelerationEvent", "value": 50, }, { "timestamp": 1637659776571, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateIdlingEvent", "value": 0, }, { "timestamp": 1637660707375, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateSpeedingEvent", "value": 67, }, { "timestamp": 1637661519707, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateHarshAccelerationEvent", "value": 71, }, { "timestamp": 1637661521773, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5","message": "CreateHarshDecelerationEvent", "value": 50, }, { "timestamp": 1637661548282, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateSpeedingEvent", "value": 62, }, { "timestamp":1637663230199, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateSpeedingEvent", "value": 66, }];
const result = violation.reduce((acc, curr) => {
  const node = acc.find(item => item.driver === curr.driver && item.company === curr.company);
  if (node) node[curr.message] ? node[curr.message] += curr.value : node[curr.message] = curr.value
  else
    acc.push({
      driver: curr.driver,
      company: curr.company,
      [curr.message]: curr.value
    });
  return acc;
}, []);
console.log(result);

owenizedd · Accepted Answer · 2021-11-24 11:26:04Z

0

You have a bug in your approach. You cant use string as key in array, so you need to change it to Object const violations = {}

Also before you do violations[key].speeding++ make sure initialized as 0 because youre trying to incerement undefined value here

answered Nov 24, 2021 at 11:26

owenizedd

1,29312 silver badges18 bronze badges

Comments

Hassan Imam · Accepted Answer · 2021-11-24 11:30:34Z

You can use array#reduce to sum up different event for same driver and company.

let violation = [ { "timestamp": 1637658787661, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateHarshAccelerationEvent", "value": 71, }, { "timestamp": 1637658789678, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateHarshDecelerationEvent", "value": 50, }, { "timestamp": 1637659776571, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateIdlingEvent", "value": 0, }, { "timestamp": 1637660707375, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateSpeedingEvent", "value": 67, }, { "timestamp": 1637661519707, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateHarshAccelerationEvent", "value": 71, }, { "timestamp": 1637661521773, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5","message": "CreateHarshDecelerationEvent", "value": 50, }, { "timestamp": 1637661548282, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateSpeedingEvent", "value": 62, }, { "timestamp":1637663230199, "driver": "7f5fda5d-86a8-471e-ae32-fcc39deb8fc7", "company": "9d8616dd-4689-4689-8812-a2345ccdcfc5", "message": "CreateSpeedingEvent", "value": 66, }],
     result = Object.values(violation.reduce((r, o) => {
      const key = o.driver + '_' + o.company;
      r[key] ??= {driver: o.driver, company: o.company};
      r[key][o.message] = (r[key][o.message] ?? 0) + o.value;
      return r;
     },{}));
console.log(result);

Collectives™ on Stack Overflow

How to get sum of specific keys values from array of object

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related