Javascript - sum of JSON Array with respect to GoLive Date , i have a json array and wanted to calculate Sum and Cumulative Average

Question

Given the following Dates:

var b = [
    {Date:'Jan 2016', steel:10.98},
    {Date:'Feb 2016', steel:5.67},
    {Date:'Jan 2016', steel:3.14},
    {Date:'Feb 2016', steel:2.14},
    {Date:'Mar 2016', steel:12.14}
]

I want to calculate both sum and cumulative average with respect to the dates shown above.

My desired output is:

Sum ->

[{"Date": "Jan 2016","val": 14.12},
{"date": "Feb 2016","val": 7.81},
{"date": "Mar 2016","val": 12.14}]

Cumulative Average ->

[{"Date": "Jan 2016","val": 7.06 },
{"date": "Feb 2016","val": 5.48},
{"date": "Mar 2016","val": 6.814}]

Possible duplicate of Merging array objects with same properies — Calvin Nunes
– Calvin Nunes, Commented Apr 18, 2018 at 12:04
Please read What is the difference between JSON and Object Literal Notation? — str
– str, Commented Apr 18, 2018 at 12:04

user9664067 · Accepted Answer · 2018-04-18 12:03:51Z

0

const sumSteelAndConcrete = (s = { steel: 0 }, c = { steel: 1 }) => s.steel + c.steel; const findByDate = (arr, date) => arr.find(item => item.Date === date);

const result = dates.map( sumSteelAndConcrete( findByDate(steelDays, date), findByDate(steelDays, date) ) ) );

answered Apr 18, 2018 at 12:03

user9664067

12 bronze badges

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

1 Comment

Calvin Nunes Over a year ago

What is this? The answer? if is this your try code, add it in an edit to the question, not as an aswer

Collectives™ on Stack Overflow

Javascript - sum of JSON Array with respect to GoLive Date , i have a json array and wanted to calculate Sum and Cumulative Average

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related