D3 中的计数总和

Sum Of count in D3

本文关键字：D3      更新时间：2023-09-26

我有如下JSON数据。

[
  {
    "avg": 996.8,
    "sessions": [
      {
        "minTime": 0,
        "maxTime": 599,
        "count": 10
      },
      {
        "minTime": 600,
        "maxTime": 1199,
        "count": 2
      },
      {
        "minTime": 1800,
        "maxTime": 2399,
        "count": 4
      },
      {
        "minTime": 2400,
        "maxTime": 2999,
        "count": 3
      }
    ],"timestamp":1449360000},
  {
    "avg": 986.4,
    "sessions": [
      {
        "minTime": 0,
        "maxTime": 599,
        "count": 12
      },
      {
        "minTime": 600,
        "maxTime": 1199,
        "count": 1
      },
      {
        "minTime": 1200,
        "maxTime": 1799,
        "count": 2
      },
      {
        "minTime": 1800,
        "maxTime": 2399,
        "count": 2
      },
      {
        "minTime": 3000,
        "maxTime": 3599,
        "count": 3
      }
    ]
    ,"timestamp":1449540000}]

我需要将数据作为

[{"avg" : 996.8,"sumcount" :19 , "timestamp":1449360000 }
{"avg": 986.4, "sumcount" :20 ,"timestamp":1449540000 }]

我尝试（我知道代码不正确，仍在添加）nest()但得到计数= 0

d3.json("Dwell.json", function(error,data){ 
var res = d3.nest()
            .key(function(d) { return d.avg; })
            .rollup(function(v) { return d3.sum(v, function (d) {return d.count})})
            .entries(data);
    console.log(JSON.stringify(res));
})

结果是[{"key":"996.8","values":0},{"key":"986.4","values":0}]

在普通的Javascript中，您可以使用Array.prototype.map()和Array.prototype.reduce()来收集计数和映射对象。

var data = [{ "avg": 996.8, "sessions": [{ "minTime": 0, "maxTime": 599, "count": 10 }, { "minTime": 600, "maxTime": 1199, "count": 2 }, { "minTime": 1800, "maxTime": 2399, "count": 4 }, { "minTime": 2400, "maxTime": 2999, "count": 3 }], "timestamp": 1449360000 }, { "avg": 986.4, "sessions": [{ "minTime": 0, "maxTime": 599, "count": 12 }, { "minTime": 600, "maxTime": 1199, "count": 1 }, { "minTime": 1200, "maxTime": 1799, "count": 2 }, { "minTime": 1800, "maxTime": 2399, "count": 2 }, { "minTime": 3000, "maxTime": 3599, "count": 3 }], "timestamp": 1449540000 }],
    result = data.map(function (a) {
        return {
            avg: a.avg,
            sumcount: a.sessions.reduce(function (s, b) { return s + b.count; }, 0),
            timestamp: a.timestamp
        };
    });
document.write('<pre>' + JSON.stringify(result, 0, 4) + '</pre>');

相关文章：
  • 没有找到相关文章