获取json值的和

Question

我有json值，我找到了特定列geo和salessale的匹配。同时，我希望接收pipelinevalue的和。我希望找到“pospension submitted”和“close won”的管道值的和作为tryfind.count.现在我得到了值o

null

const data ={
   "pipeline":{
      "data":[
         {
            "UserName":"Jaison Clinton",
            "Geo":"NSU",
            "SalesStage":"Proposal Submitted",
            "PipelineValue":"3,54,000"
            
         },
         {
            "UserName":"Jaison Clinton",
            "Geo":"NSU",
            "SalesStage":"Proposal Submitted",
            "PipelineValue":"3,49,000"
         },
         {
            "UserName":"Kaviarasan Selvaraj",
            "Geo":"NSU",
            "SalesStage":"Proposal Submitted",
            "PipelineValue":"70,000"
         },
         {
            "UserName":"Vivek Sharma",
            "Geo":"NSU",
            "SalesStage":"close won",
            "PipelineValue":"13,45,000"
            
         }
      ]
   }
};
const result = data.pipeline.data.reduce((acc, lead) => {
    const tryFind = acc.find(l => l.Geo === lead.Geo && l.SalesStage === lead.SalesStage);
var PipelineValue=0;
    if (tryFind) {
        tryFind.count++;
        PipelineValue=PipelineValue+lead.PipelineValue;
    } else {
        acc.push({ Geo: lead.Geo, SalesStage: lead.SalesStage, count: 1 ,PipelineValue:PipelineValue});
    }

    return acc;
}, []);

console.log(result);

null

希望popeline值为773,000（nsu geo“提案提交”的总和）和13,45,000（nsu geo close won的总和）

Answer 1

我可能会这样写:

null

const extract = data => Object.values (
  data .reduce ((a, {Geo, SalesStage, PipelineValue}) => {
    const key = Geo + '~' + SalesStage
    return {...a, [key]: {
      Geo,
      SalesStage,
      count: (((a[key] || {}).count) || 0) + 1,
      PipelineValue: ((a[key] || {}).PipelineValue || 0) + 
                     Number(PipelineValue.replace(/,/g, ''))
    }}
  }, {})
)

const data = {pipeline: {data: [{UserName: "Jaison Clinton", Geo: "NSU", SalesStage: "Proposal Submitted", PipelineValue: "3,54,000"}, {UserName: "Jaison Clinton", Geo: "NSU", SalesStage: "Proposal Submitted", PipelineValue: "3,49,000"}, {UserName: "Kaviarasan Selvaraj", Geo: "NSU", SalesStage: "Proposal Submitted", PipelineValue: "70,000"}, {UserName: "Vivek Sharma", Geo: "NSU", SalesStage: "close won", PipelineValue: "13,45,000"}]}}


console .log (extract (data .pipeline .data))

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

Answer 2

整件事分为两行:

const result = data.pipeline.data.reduce((acc,lead)=> 
               (acc+=+lead.PipelineValue.replace(/,/g,''),acc), 0);

好的，经过编辑，下面是不同geos和salesstages的总和:

null

const data ={
   "pipeline":{
      "data":[
         {
            "UserName":"Jaison Clinton",
            "Geo":"NSU",
            "SalesStage":"Proposal Submitted",
            "PipelineValue":"3,54,000"
            
         },
         {
            "UserName":"Jaison Clinton",
            "Geo":"NSU",
            "SalesStage":"Proposal Submitted",
            "PipelineValue":"3,49,000"
         },
         {
            "UserName":"Kaviarasan Selvaraj",
            "Geo":"NSU",
            "SalesStage":"Proposal Submitted",
            "PipelineValue":"70,000"
         },
         {
            "UserName":"Vivek Sharma",
            "Geo":"NSU",
            "SalesStage":"close won",
            "PipelineValue":"13,45,000"
            
         }
      ]
   }
};
const result = Object.entries(data.pipeline.data.reduce((acc,cur) => { 
      let k=cur.Geo+'|'+cur.SalesStage;
      (acc[k]=acc[k] || []).push(+cur.PipelineValue.replace(/,/g,''))
      return acc}, {}))
    .map(e=>{
      let k=e[0].split('|'); 
      return {Geo:k[0],SalesStage:k[1],count:e[1].length,PipelineValue:e[1].reduce((a,c)=>a+c)} 
     });
console.log(result);

Answer 3

如果删除PipelineValue值中的逗号，就可以将这些字符串强制转换为数字。 如果无法在源代码中更改格式，可以在脚本中轻松完成:

js prettyprint-override">// Original line
PipelineValue=PipelineValue+lead.PipelineValue;

// Replace commas with nothing, then cast as number (using unary +)
PipelineValue=PipelineValue+(+lead.PipelineValue.replace(/,/g,''));