Angular - How to use sum and group by

Question

I need to group the records based on ID and display sum of weight. can someone please let me know the sum and group by method in Angular.

API Response:

data = [
  {Id:1, name: 'ABC', weight: 10 },
  {Id:1, name: 'ABC', weight: 14 },
  {Id:1, name: 'ABC', weight: 16 },
  {Id:2, name: 'DEF', weight: 23 },
  {Id:2, name: 'DEF', weight: 22 },
  {Id:4, name: 'GHI', weight: 44 },
  {Id:4, name: 'GHI', weight: 41 }
]

Expected output:

dataResult =  [
      {Id:1, name: 'ABC', weight: 40 },
      {Id:2, name: 'DEF', weight: 45 },
      {Id:4, name: 'GHI', weight: 85 }
    ]

Have look at this stackoverflow.com/questions/24444738/…

Janak Prajapati
– Janak Prajapati

2020-05-18 07:41:02 +00:00
Commented May 18, 2020 at 7:41 — Janak Prajapati
– Janak Prajapati, Commented May 18, 2020 at 7:41

Harun Yilmaz · Accepted Answer · 2020-05-18 07:44:19Z

2

You can use Array.reduce() to iterate over and Array.find() to find item by id. Then you can calculate the sum as followings:

const data = [
  {Id:1, name: 'ABC', weight: 10 },
  {Id:1, name: 'ABC', weight: 14 },
  {Id:1, name: 'ABC', weight: 16 },
  {Id:2, name: 'DEF', weight: 23 },
  {Id:2, name: 'DEF', weight: 22 },
  {Id:4, name: 'GHI', weight: 44 },
  {Id:4, name: 'GHI', weight: 41 }
]

const calculated = data.reduce((acc, item) => {
  
  let accItem = acc.find(ai => ai.Id === item.Id)
  
  if(accItem){
      accItem.weight += item.weight 
  }else{
     acc.push(item)
  }

  return acc;
},[])

console.log(calculated)

answered May 18, 2020 at 7:44

Harun Yilmaz

8,5793 gold badges30 silver badges40 bronze badges

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

2 Comments

Tech Learner Over a year ago

Thanks, your solution working for me. Is it possible to group based on two columns. In find can we use two columns?

Harun Yilmaz Over a year ago

You're welcome. Glad to hear it worked for you. Of course, you can expand the condition statement in find(): acc.find(ai => ai.Id === item.Id && ai.name === item.name) etc.

Șold Andrei-Alexandru · Accepted Answer · 2020-05-18 07:57:52Z

I wrote it in JavaScript, you can easily convert it to TypeScript.

data = [
  {Id:1, name: 'ABC', weight: 10 },
  {Id:1, name: 'ABC', weight: 14 },
  {Id:1, name: 'ABC', weight: 16 },
  {Id:2, name: 'DEF', weight: 23 },
  {Id:2, name: 'DEF', weight: 22 },
  {Id:4, name: 'GHI', weight: 44 },
  {Id:4, name: 'GHI', weight: 41 }
]

function entryIdAlreadyExists(dataEntries, entry) {
    for (let dataEntry of dataEntries) {
        if (entry.Id === dataEntry.Id) {
            return true;
        }
    }
    return false;
}

function updateWeightForEntryWithId (dataEntries, entry) {
    for (let dataEntry of dataEntries) {
        if (entry.Id === dataEntry.Id) {
            dataEntry.weight = dataEntry.weight + entry.weight;           
        }
    }
    return dataEntries;
}

let result = [];
for (let entry of data) {
    if (entryIdAlreadyExists(result, entry)) {
        result = updateWeightForEntryWithId (result, entry);
    } else {
        result.push(entry);
    }
}

console.log(result);

Collectives™ on Stack Overflow

Angular - How to use sum and group by

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related