Utilize JavaScript array to filter, match, and perform calculations based on dates and names

Question

Utilize JavaScript array to filter, match, and perform calculations based on dates and names

I am working with the following dataset:

const data = [
  {
    "employee_name": "Employee A",
    "commission_date": "14/05/2018",
    "commission_price": 9000
  },
  {
    "employee_name": "Employee A",
    "commission_date": "17/05/2018",
    "commission_price": 5000
  },
  {
    "employee_name": "Employee B",
    "commission_date": "18/05/2018",
    "commission_price": 2000
  },
  {
    "employee_name": "Employee B",
    "commission_date": "18/05/2018",
    "commission_price": 5000
  },
  {
    "employee_name": "Employee B",
    "commission_date": "19/05/2018",
    "commission_price": 500
  }
]

I need to calculate the total commission_price based on matching employee_name and commission_date.

The expected output should be:

[
  {
    "employee_name": "Employee A",
    "commission_date": "14/05/2018",
    "commission_price": 9000
  },
  {
    "employee_name": "Employee A",
    "commission_date": "17/05/2018",
    "commission_price": 5000
  },
  {
    "employee_name": "Employee B",
    "commission_date": "18/05/2018",
    "commission_price": 7000
  },
  {
    "employee_name": "Employee B",
    "commission_date": "19/05/2018",
    "commission_price": 500
  }
]

I have attempted to implement a solution using code from similar questions, but the results are only grouped by employee_name. Here is the code snippet I used:

let result = Object.values(data.reduce((r, { employee_name, commission_price }) => {
  r[employee_name] = r[employee_name] || { employee_name, commission_price : 0 }
  r[employee_name].commission_price += commission_price
  return r
}, {}))

Thank you.

javascript arrays

Answer 1

Answer №1

If you want to handle multiple groups efficiently, consider using a combined key approach.

var data = [{ employee_name: "Employee A", commission_date: "14/05/2018", commission_price: 9000 }, { employee_name: "Employee A", commission_date: "17/05/2018", commission_price: 5000 }, { employee_name: "Employee B", commission_date: "18/05/2018", commission_price: 2000 }, { employee_name: "Employee B", commission_date: "18/05/2018", commission_price: 5000 }, { employee_name: "Employee B", commission_date: "19/05/2018", commission_price: 500 }], 
    result = Object.values(data.reduce((r, o) => {
        var key = ['employee_name', 'commission_date'].map(k => o[k]).join('|');
        r[key] = r[key] || { employee_name: o.employee_name, commission_date: o.commission_date, commission_price : 0 };
        r[key].commission_price += o.commission_price;
        return r;
    }, {}));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Answer 2

If you want to handle multiple groups efficiently, consider using a combined key approach.

var data = [{ employee_name: "Employee A", commission_date: "14/05/2018", commission_price: 9000 }, { employee_name: "Employee A", commission_date: "17/05/2018", commission_price: 5000 }, { employee_name: "Employee B", commission_date: "18/05/2018", commission_price: 2000 }, { employee_name: "Employee B", commission_date: "18/05/2018", commission_price: 5000 }, { employee_name: "Employee B", commission_date: "19/05/2018", commission_price: 500 }], 
    result = Object.values(data.reduce((r, o) => {
        var key = ['employee_name', 'commission_date'].map(k => o[k]).join('|');
        r[key] = r[key] || { employee_name: o.employee_name, commission_date: o.commission_date, commission_price : 0 };
        r[key].commission_price += o.commission_price;
        return r;
    }, {}));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Utilize JavaScript array to filter, match, and perform calculations based on dates and names

Answer №1

Similar questions

Arranging search findings based on relevance using javascript

Ways to Execute the Constructor or ngOnInit Multiple Times

Record details to text file after the button is clicked on ASP.NET

Accessing Elements by Class Name

Is there a way to retrieve a single value using AJAX instead of returning the entire HTML page?

How can I enable two-finger scrolling on mobile web browsers?

Tips for creating equal height columns in Bootstrap 4

Converting UK DateTime to GMT time using Angular

Instructions for removing all entries from a DynamoDB table

Troubleshooting Vue.js Error: Uncaught ReferenceError - jQuery Undefined

Using data fetched from PHP in HTML via jQuery post: A step-by-step guide

Automatically fill in an input field with jQuery by using the value from another input field

Tips on integrating googleapis with apps script

Trigger an AJAX request to execute a PHP script when a button is clicked

How can I create a custom validator in Angular 2 that trims the input fields?

Is there a way to use JavaScript to change the text displayed in this ASPX control?

MUI: How can I resolve the issue of TextField not supporting the number type with maxLength restriction?

``Please note that the Sinon spy.called method is currently not

Avoid an excessive number of XHR/AJAX requests when using the Facebook embedded iframe

The res.sendFile() function quickly delivers a 204 no content response