So here is where I am at right now.
I've restructured my data as follows
Date in Date format, year*10000+month*100+day, Data column 1,2,3,4
But i'm not sure how tie back data2 to duplicate your trick. Once again I
appreciate any help you can provide.
function doGet() {
var ss = SpreadsheetApp.openById('Hidden');
var data = ss.getDataRange();
var dateFilter =
Charts.newNumberRangeFilter().setFilterColumnIndex(1).build();
var areaChart = Charts.newAreaChart()
.setDataViewDefinition(Charts.newDataViewDefinition().setColumns([0,2,3,4,5]))
.setStacked()
.setLegendPosition(Charts.Position.BOTTOM)
.setTitle('Bug Status Over Time')
.setXAxisTitle('Date')
.setYAxisTitle('Count')
.setDimensions(900, 500)
.build();
var dashboard = Charts.newDashboardPanel().setDataTable(data)
.bind([dateFilter], [areaChart])
.build();
var data2 = Charts.newDataTable()
.addColumn(Charts.ColumnType.NUMBER, 'Index')
.addColumn(Charts.ColumnType.STRING, 'name')
.addRow([0,'date']);
for (var i = 2; i < ss.getLastColumn(); i ++) {
data2.addRow([i,ss.getSheetValues(1, i +1, 1, 1).join()]);
}
data2.build();
var table = Charts.newTableChart()
.setDataTable(data2)
.build()
var app = UiApp.createApplication();
var filterPanel = app.createVerticalPanel();
var chartPanel = app.createHorizontalPanel();
filterPanel.add(dateFilter).setSpacing(5);
chartPanel.add(areaChart);
dashboard.add(app.createVerticalPanel().add(filterPanel).add(chartPanel));
app.add(dashboard).add(table);
return app;
}
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
