如何在Google Apps脚本中设置"aggregate data series“为average而不是sum？

function setAggregateDataSeriesToAverage() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); // 替换为你的工作表名称
  var charts = sheet.getCharts();

  for (var i = 0; i < charts.length; i++) {
    var chart = charts[i];
    var options = chart.getOptions();

    // 设置"aggregate data series"为average
    options.setAggregateDataSeries(Charts.ChartType.AVERAGE);

    // 更新图表选项
    chart = chart.modify();
    chart = chart.setOptions(options);

    // 更新工作表上的图表
    sheet.updateChart(chart);
  }
}