Get sum from the nested array of objects

Question

I have below array of objects. As you can see, there is a nested object named count in each of these objects. I want to get total of Closed, Verify and Analyze

For e.g. the total of Closed is 23, Verify is 3 and Analyze is 20

"byPerson": [
      {
        "personId": "973567318",
        "firstName": "Others",
        "lastName": "",
        "count": {
          "Closed": 7,
          "Verify": 3,
          "Analyze": 19
        }
      },
      {
        "personId": "1514903899",
        "firstName": "Yatish",
        "lastName": "Patel",
        "count": {
          "Closed": 16,
          "Analyze": 1
        }
      }
 ]

I tried this way but it didnt work. for e.g to get total of Closed

cosnt result = data.reduce((a, b) => ({"Closed": a.count["Closed"] + b.count["Closed"]}));

Christian Fritz · Accepted Answer · 2021-04-27 23:45:58Z

2

const byPerson = [
      {
        "personId": "973567318",
        "firstName": "Others",
        "lastName": "",
        "count": {
          "Closed": 7,
          "Verify": 3,
          "Analyze": 19
        }
      },
      {
        "personId": "1514903899",
        "firstName": "Yatish",
        "lastName": "Patel",
        "count": {
          "Closed": 16,
          "Analyze": 1
        }
      }
 ];
const sum = byPerson.reduce((agg, item) => {
  ['Closed', 'Verify', 'Analyze'].forEach(f => agg[f] += item.count[f] || 0);
  return agg;
}, {Closed: 0, Verify: 0, Analyze: 0});
console.log(sum);

answered Apr 27, 2021 at 23:45

Christian Fritz

21.5k3 gold badges48 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Drew Reese · Accepted Answer · 2021-04-27 23:55:17Z

1

Reduce the data into an object with the keys for the nested properties you want to total. In the reduce callback destructure the "totals" properties and the nested count property and compute the summation.

const data = [
  {
    "personId": "973567318",
    "firstName": "Others",
    "lastName": "",
    "count": {
      "Closed": 7,
      "Verify": 3,
      "Analyze": 19
    }
  },
  {
    "personId": "1514903899",
    "firstName": "Yatish",
    "lastName": "Patel",
    "count": {
      "Closed": 16,
      "Analyze": 1
    }
  }
];

const totalCount = data.reduce(({
  Closed,
  Analyze,
  Verify
}, {
  count
}) => ({
  Closed: Closed + (count?.Closed || 0),
  Analyze: Analyze + (count?.Analyze || 0),
  Verify: Verify + (count?.Verify || 0),
}), {
  Closed: 0,
  Analyze: 0,
  Verify: 0,
});

console.log(totalCount);

edited Apr 27, 2021 at 23:55

answered Apr 27, 2021 at 23:44

Drew Reese

207k19 gold badges280 silver badges293 bronze badges

6 Comments

Aren Trot Over a year ago

Resse- i ran the code snippet but it gave me error.

Drew Reese Over a year ago

@ArenTrot Ack, the "tidy" button changed the syntax. Sorry about that, it should be fixed now.

Aren Trot Over a year ago

Resse- When i use this code, it tells me data.reduce is not a function

almarc Over a year ago

It returns 23, 20, 0, not 23, 20, 3

Drew Reese Over a year ago

@ArenTrot I named the array data in my snippet, it may have a different name in your actual code.

|

charlietfl · Accepted Answer · 2021-04-28 00:00:09Z

1

This is a case where you really don't even need reduce and can use a simple loop as well as iterate the Object.keys()

const byPerson = [
      {
        "personId": "973567318",
        "firstName": "Others",
        "lastName": "",
        "count": {
          "Closed": 7,
          "Verify": 3,
          "Analyze": 19
        }
      },
      {
        "personId": "1514903899",
        "firstName": "Yatish",
        "lastName": "Patel",
        "count": {
          "Closed": 16,
          "Analyze": 1
        }
      }
 ];
 
const sum =  {Closed: 0, Verify: 0, Analyze: 0}

byPerson.forEach(({count})=> {
   Object.keys(sum).forEach(k => sum[k] += (count[k] || 0))
});
 

console.log(sum);

answered Apr 28, 2021 at 0:00

charlietfl

172k14 gold badges125 silver badges154 bronze badges

Collectives™ on Stack Overflow

Get sum from the nested array of objects

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related