以编程方式透视 Google 可视化数据表

2022-01-22 00:00:00 pivot javascript google-visualization datatable

我对 this fiddle 感到兴奋，并尝试参考该小提琴创建相同的类型.我的修改示例在 here 中给出，我正在尝试创建如下视图.

I excited with this fiddle and I tried to create the same kind with reference to that fiddle. My modified sample is given in here and i'm trying to create a view as follows.

var distinctValues = data.getDistinctValues(2);

    var viewColumns = [1];
    var groupColumns = [];
    // build column arrays for the view and grouping
    for (var i = 0; i < distinctValues.length; i++) {
        viewColumns.push({
            type: 'number',
            label: distinctValues[i],
            aggregation: google.visualization.data.count
        });
        groupColumns.push({
            column: i+1,
            type: 'number',
            //label: distinctValues[i],
            aggregation: google.visualization.data.sum
        });
    }

但我的目标是创建一个如下所示的数据透视表.

But my aim is to create a pivot table something like as follows.

['Column1', 'Column2', 100, 200, 300, 400],
['A', 'bar', 0, 1, 1, 0],
['A', 'baz', 0, 0, 1, 0],
['A', 'foo', 3, 1, 0, 0],
['B', 'baz', 0, 1, 0, 0],
['B', 'cad', 1, 0, 1, 1],
['B', 'qud', 1, 1, 1, 2]

我该如何继续?

推荐答案

您必须更改代码中的一些内容.首先，如果您希望 Column1 和 Column2 都在输出中，则 viewColumns 需要同时包含第 0 列和第 1 列.然后，您需要调整添加到 viewColumns 的列:每个列都需要一个计算列中值的 calc 参数.在这种情况下，您希望将列的值与 distinctValues[i] 进行比较，并在匹配时返回 1，在不匹配时返回 0.在 groupColumns 的聚合函数中，使用 sum 而不是 count:

You have to change a few things in your code. First, the viewColumns needs to contain both columns 0 and 1 to start if you want Column1 and Column2 to both be in the output. Then, you need to adjust the columns you add to the viewColumns: each one needs a calc parameter which calculates the value in the column. In this case, you want to compare the value of the column to distinctValues[i] and return 1 when they match and 0 when they don't. In the aggregation function for groupColumns, use sum instead of count:

var distinctValues = data.getDistinctValues(2);

var viewColumns = [0, 1];
var groupColumns = [];
// build column arrays for the view and grouping
for (var i = 0; i < distinctValues.length; i++) {
    viewColumns.push({
        type: 'number',
        label: distinctValues[i],
        calc: (function (x) {
            return function (dt, row) {
                return (dt.getValue(row, 2) == x) ? 1 : 0;
            }
        })(distinctValues[i])
    });
    groupColumns.push({
        column: i+2,
        type: 'number',
        //label: distinctValues[i],
        aggregation: google.visualization.data.sum
    });
}

然后，在分组函数中，传递第一个数组中的第 0 列和第 1 列:

Then, in the grouping function, pass columns 0 and 1 in the first array:

var pivotedData = google.visualization.data.group(view, [0, 1], groupColumns);

var pivotedData = google.visualization.data.group(view, [0, 1], groupColumns);

在此处查看这些更改:http://jsfiddle.net/asgallant/DUn6B/1/

相关文章