过滤并重新绘制google.visualization.DataTable时，需要重新计算列值

Need to recalculate column values when google.visualization.DataTable is filtered and redrawn

本文关键字：新计算 计算 visualization 新绘制 绘制 google DataTable 过滤      更新时间：2023-09-26

我有以下代码：

 //creates a DataTable. don't worry about this. this works
var projectData = createDataView(json);
// Create and draw the visualization.
var table = new google.visualization.ChartWrapper({
    chartType: "Table",
    containerId: "projectChart"
});
// add user filter
var userFilter = new google.visualization.ControlWrapper({
    'controlType': 'StringFilter',
    'containerId': 'userFilter',
    'options': {
        'filterColumnLabel': 'User'
    }
});
var dashboard = new google.visualization.Dashboard(
            document.getElementById('projectChartContainer'))
        .bind(userFilter, table);
function drawTable() 
{
    dashboard.draw(projectData, {
        'allowHtml': true,
        showRowNumber: true,
        title: "Project Data",
        width: middleWidth
    });

    // google visualization styles
    $(".google-visualization-table-td-number").addClass("small");
    $(".google-visualization-table-td-center").addClass("eighty");
}
// set width 
middleWidth = $("#contentMiddle").width();
drawTable();
// if user resized the browser, change the width and redraw.  
//this is ugly, but the only way i could find. 100% was buggy
$(window).resize( function() {
    middleWidth = $(window).width()-142;
    drawTable();
});
// add a change listener to table
google.visualization.events.addListener(table, 'ready', function() {                    
    // get hour totals
    var workedHours = 0;
    var billedHours = 0;
    // THIS IS WHERE I NEED HELP!!!!!       
    /*var dataLength = table.getNumberOfRows();
    for (var x = 0; x < dataLength; x++)
    {
        workedHours += table.getValue(x, 7);
        billedHours += table.getValue(x, 9);
    }
    $("#totalWorked").text(workedHours);
    $("#totalBilled").text(billedHours);
    $("#totalsContainer").show();*/
    console.log(projectData.getValue(1,1));
});

就表的显示和过滤而言，一切都很好。我需要的是一种获取新筛选的表的列总数的方法。我可以第一次使用projectData.getValue（）来获取值，但无论过滤掉什么，它都会返回相同的值。我可能在新绘制的表中没有行，它将显示与最初相同的值。我并不感到惊讶，因为我只是在改变表格，等待重新绘制。但我无法从表中获取任何值。我上面为table提供的函数（即…table.getNumberOfRows（））不存在。这正是我希望发生的事情。关于如何获得筛选表的新列值，有什么想法吗？

我的建议是先用var tableData = table.getDataTable(); 将表数据转入数据表

该dataTable将按照您的表中所示进行筛选和排序。然后，您可以在tableData:上运行for（）循环

for (var x = 0; x < tableData.getNumberOfRows(); x++)
{
    workedHours += tableData.getValue(x, 7);
    billedHours += tableData.getValue(x, 9);
}
$("#totalWorked").text(workedHours);
$("#totalBilled").text(billedHours);
$("#totalsContainer").show();
相关文章：