通过在dc.js中比较另外两个维度中的数据来维度中的数据总和

问题描述：

我被卡住了，需要通过使用由其他两个维度索引的数据找到一个维度的数据总和。通过在dc.js中比较另外两个维度中的数据来维度中的数据总和

例子：

"mode_device","method","discount","time","first_time","paid","p_id","p_sku" 
"Desktop","EBS",,"1344887090","1344887090","1079","8786","PPLB03571285" 
"Desktop","MOBIKWIK-WALLET","89","1474371140","1474371140","591","99068","PPLB009DCBBFREE" 
"AndroidApp","COD","97","1474371149","1438844849","647","72321","PPLB034601" 
"Desktop","JUSPAY","60","1474371158","1474371158","398","92389","PPLB713SQ306" 
"AndroidApp","COD","190","1474371247","1448993680","1261","72685","PLB0029regenerist3" 
"Desktop","JUSPAY","90","1474371346","1474371346","599","86728","PPLB66719804817" 
"Desktop","DEBITCARD","60","1474371366","1465733603","398","92389","PPLB713SQ306" 
"AndroidApp","COD","0","1474371404","1474371404","577","106032","PPLB0335PA0990NM" 
"Desktop","COD","43","1474371404","1468956726","356","13221","PPLB039605"

在这里，我们比较mode_device和method，我们必须从支付返回数据的总和。

例子： AndroidApp和COD可以重复几次可以说数据有类似

"Android","COD","234" 
"Android","Ebs","234" 
"Ios","COD","234" 
"Ios","COD","234" 
"Android","COD","234"

我们必须使用dc.js图表返回像

Android-COD:468 
Android-Ebs:234 
Ios-COD:468

。

答

我不清楚你的问题你想如何绘制这些数据 - 它会是一个条形图，条形图上标有两个字段吗？

但是，如果你想既mode_device和method聚集，你可以简单地创建一个使用这两个值在其主要维度：

var modeMethodDimension = cf.dimension(function(d) { return [d.mode_device, d.method].join('-'); }); 
var modeMethodGroup = modeMethodDimension.group(function(d) { return +d.paid; });

现在组应具有键值对像

[{key: 'Android-COD', value: 468}, {key: 'Android-Ebs', value: 234}, ...]

如果你把它放到dc.barChart这些键将是条的名称。

通过在dc.js中比较另外两个维度中的数据来维度中的数据总和

相关推荐