Class DataViewDefinitionBuilder

functiondoGet(){
// This example creates two table charts side by side. One uses a data view
// definition to restrict the number of displayed columns.
// Get sample data from a spreadsheet.
constdataSourceUrl='https://docs.google.com/spreadsheet/tq?range=A1%3AF'+
'&key=0Aq4s9w_HxMs7dHpfX05JdmVSb1FpT21sbXd4NVE3UEE&gid=4&headers=-1';
// Create a chart to display all of the data.
constoriginalChart=Charts.newTableChart()
.setDimensions(600,500)
.setDataSourceUrl(dataSourceUrl)
.build();
// Create another chart to display a subset of the data (only columns 1 and
// 4).
constdataViewDefinition=Charts.newDataViewDefinition().setColumns([0,3]);
constlimitedChart=Charts.newTableChart()
.setDimensions(200,500)
.setDataSourceUrl(dataSourceUrl)
.setDataViewDefinition(dataViewDefinition)
.build();
consthtmlOutput=HtmlService.createHtmlOutput();
constoriginalChartData=Utilities.base64Encode(
originalChart.getAs('image/png').getBytes(),
);
constoriginalChartUrl=
`data:image/png;base64,${encodeURI(originalChartData)}`;
constlimitedChartData=Utilities.base64Encode(
limitedChart.getAs('image/png').getBytes(),
);
constlimitedChartUrl=
`data:image/png;base64,${encodeURI(limitedChartData)}`;
htmlOutput.append('<table><tr><td>');
htmlOutput.append(`<img border="1" src="${originalChartUrl}">`);
htmlOutput.append('</td><td>');
htmlOutput.append(`<img border="1" src="${limitedChartUrl}">`);
htmlOutput.append('</td></tr></table>');
returnhtmlOutput;
}