Grouping by multiple fields in Nodejs using Lodash

Question

I am currently grouping my data by account but also need to group it by salesperson too. However, I cannot figure out how to successfully implement the functionality so that it is grouping by multiple fields at the same time. Could someone offer up some guidance as to how I can do that?

Here is my function that groups my data as of right now:

filteredData[rep.id] = _.chain(filteredData[rep.id]).groupBy('account').map(function(v, i) {
          return {
              customer: i,
              salesperson: _.reduce(v, function(res, val) {
                  return val['salesperson'];
              },0),
              sales_ytd: _.reduce(v, function(res, val) {
                  return res + Number(val['sales - ytd']);
              },0),
              mgn$_ytd: _.reduce(v, function(res, val) {
                  return res + Number(val['margin - ytd']);
              },0),
              sales_last: _.reduce(v, function(res, val) {
                  return res + Number(val['sales - pytd']);
              },0),
              mgn$_last: _.reduce(v, function(res, val) {
                  return res + Number(val['margin - pytd']);
              },0)
    }
}).value();

Ori Drori · Accepted Answer · 2018-12-20 14:56:02Z

1

You need to combine the field values when you need to group by multiple fields.

Example (not tested):

filteredData[rep.id] = _(filteredData[rep.id])
  .groupBy(function(o) {
    return o.account + '-'  + o.salesperson;
  })
  .map(function(v, i) {
    var customer = _.head(_.words(i));

    return {
        customer: customer,
        salesperson: _.reduce(v, function(res, val) {
            return val['salesperson'];
        },0),
        sales_ytd: _.reduce(v, function(res, val) {
            return res + Number(val['sales - ytd']);
        },0),
        mgn$_ytd: _.reduce(v, function(res, val) {
            return res + Number(val['margin - ytd']);
        },0),
        sales_last: _.reduce(v, function(res, val) {
            return res + Number(val['sales - pytd']);
        },0),
    mgn$_last: _.reduce(v, function(res, val) {
        return res + Number(val['margin - pytd']);
    },0)
};

}).value();

answered Dec 20, 2018 at 14:56

Ori Drori

196k32 gold badges243 silver badges233 bronze badges

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

1 Comment

Rataiczak24 Over a year ago

this works great and solved the problem...thank you!

Eric Van Der Dijs · Accepted Answer · 2018-12-20 14:59:05Z

It is a little unclear to understand your code without the input data and the expected result, but, I believe that you are grouping the data and formatting the result on one sweep. maybe you could consider separating the concerns of the function writing:

const formatData = (object, index) => {
  return =  {
    customer: index,
    salesperson: _.reduce(object, function(res, val) {
        return val['salesperson'];
    },0),
    sales_ytd: _.reduce(object, function(res, val) {
        return res + Number(val['sales - ytd']);
    },0),
    mgn$_ytd: _.reduce(object, function(res, val) {
        return res + Number(val['margin - ytd']);
    },0),
    sales_last: _.reduce(object, function(res, val) {
        return res + Number(val['sales - pytd']);
    },0),
    mgn$_last: _.reduce(object, function(res, val) {
        return res + Number(val['margin - pytd']);
    },0)
  }
}

Then you could iterate over a list of grouping clases and return an object containing several groups:

const groupFormatedDataBy = ( ...groupingClasses ) => {
  let output = {}
  grupingClasses.forEach(groupingClass => {

    output[groupingClass] = _.chain(filteredData[rep.id])
       .groupBy(groupingClass)
       .map( formatData )
       .value();

  })

  return output
}

PS: I could not test the code without sample data jejeje, hope it helps you

Collectives™ on Stack Overflow

Grouping by multiple fields in Nodejs using Lodash

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related