Summing values of JSON objects in javascript

Question

I have an API that returns data such as this:

{
        "attributes": {
            "type": "Opportunity"
        },
        "Amount": 175.36,
        "Owner": {
            "attributes": {
                "type": "User"
            },
            "Name": "Steve Knight"
        }
    },

    {
        "attributes": {
            "type": "Opportunity"
        },
        "Amount": 6800,
        "Owner": {
            "attributes": {
                "type": "User"
            },
            "Name": "Bob Smith"
        }
    }
etc...

These represent opportunities and so each salesperson will have multiple. I am trying to return an object that sums the amounts for each salesperson and returns something like:

{Steve Knight: 5590, Bob Smith: 98722, John Jones: 12347893}

I have tried grouping the objects by owner name however I am not sure how to then sum the amounts

var groupBy = require('lodash.groupby');

var grouped = groupBy(data, function(x) {
        return x.Owner.Name;
      });

Have a look on this: stackoverflow.com/questions/14446511/… — Sunil tc
– Sunil tc, Commented Mar 11, 2020 at 10:36

yunzen · Accepted Answer · 2020-03-11 10:37:15Z

Best to use the reduce method of Array.prototype

console.clear();

(function() {
  "use strict";

  function reduce(coll, elem, idx, arr) {
    coll[elem.Owner.Name] = coll[elem.Owner.Name] || 0;
    coll[elem.Owner.Name] += elem.Amount

    return coll;
  }

  const data = [
    {
      attributes: {
        type: "Opportunity"
      },
      Amount: 175.36,
      Owner: {
        attributes: {
          type: "User"
        },
        Name: "Steve Knight"
      }
    },

    {
      attributes: {
        type: "Opportunity"
      },
      Amount: 100.16,
      Owner: {
        attributes: {
          type: "User"
        },
        Name: "John Doe"
      }
    },

    {
      attributes: {
        type: "Opportunity"
      },
      Amount: 6.00,
      Owner: {
        attributes: {
          type: "User"
        },
        Name: "John Doe"
      }
    },

    {
      attributes: {
        type: "Opportunity"
      },
      Amount: 101.65,
      Owner: {
        attributes: {
          type: "User"
        },
        Name: "Steve Knight"
      }
    },

    {
      attributes: {
        type: "Opportunity"
      },
      Amount: 6800,
      Owner: {
        attributes: {
          type: "User"
        },
        Name: "Bob Smith"
      }
    }
  ];

  const reducedData = data.reduce(reduce, {})

  console.log(reducedData)
}());

EugenSunic · Accepted Answer · 2020-03-11 10:54:21Z

1

If key name exists than accumulate the already existing value to the new one, otherwise just add the initial value and name

const arr = [{
    "attributes": {
      "type": "Opportunity"
    },
    "Amount": 175.36,
    "Owner": {
      "attributes": {
        "type": "User"
      },
      "Name": "Steve Knight"
    }
  },
  {
    "attributes": {
      "type": "Opportunity"
    },
    "Amount": 100,
    "Owner": {
      "attributes": {
        "type": "User"
      },
      "Name": "Steve Knight"
    }
  },

  {
    "attributes": {
      "type": "Opportunity"
    },
    "Amount": 6800,
    "Owner": {
      "attributes": {
        "type": "User"
      },
      "Name": "Bob Smith"
    }
  }
]


const result = arr.reduce((acc, x) => {
  const key = x.Owner.Name;
  const amount = x['Amount'];

  if (!acc[key]) {
    acc[key] = amount;
  } else {
    acc[key] = acc[key] + amount;
  }

  return acc;
}, {});
console.log(result)

edited Mar 11, 2020 at 10:54

answered Mar 11, 2020 at 10:38

EugenSunic

13.8k15 gold badges68 silver badges96 bronze badges

3 Comments

rplantiko Over a year ago

Is there a reason why you write acc = { ...acc, [key]:amount} instead of simply acc[key] = amount ?

EugenSunic Over a year ago

@rplantiko you are right, just got used it because of mutating the sate sometimes, it doesn't impact the performance anyways and garbage collector does it's job pretty well

yunzen Over a year ago

By sate you mean state

Abhishek Kulkarni · Accepted Answer · 2020-03-11 10:37:06Z

0

You can try this below:

let output = {}
data.map(function (item) {
    if (output.hasOwnProperty(item.Owner.Name)) {
            output[item.Owner.Name] = item.Amount;
    } else {
            output[item.Owner.Name] += item.Amount;
    }
 });

answered Mar 11, 2020 at 10:37

Abhishek Kulkarni

1,7671 gold badge8 silver badges9 bronze badges

Collectives™ on Stack Overflow

Summing values of JSON objects in javascript

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related