JavaScript
function drawVisualization() {
// Prepare the data
var data = google.visualization.arrayToDataTable([
["Program Number","Year","Total","Extended","Nat Median Total","Certainty for Nat Median Total","Nat Median Extended","Certainty for Nat Median Extended"],
["107000","2006",7852,6247,4598,false,1265,false],
["107000","2007",6523,6523,4598,false,1265,false],
["107000","2008",7413,3526,4598,false,1265,false],
["107000","2009",6821,1254,4598,false,1265,false],
["107000","2010",2354,9723,4598,false,1265,false],
["107000","2011",9762,3548,4598,false,1265,false],
["120000","2006",6824,4574,4598,false,1265,false],
["120000","2007",3258,2236,4598,false,1265,false],
["120000","2008",7496,4716,4598,false,1265,false],
["120000","2009",6899,3526,4598,false,1265,false],
["120000","2010",1547,8747,4598,false,1265,false],
["120000","2011",3587,7462,4598,false,1265,false]
]);
data.setColumnProperty(5, 'role', 'certainty');
data.setColumnProperty(7, 'role', 'certainty');
// Define a category picker control for the Program Number column
var chooseProgram = new google.visualization.ControlWrapper({
'controlType': 'CategoryFilter',
'containerId': 'chooseprogram',
'options': {
'filterColumnLabel': 'Program Number',
'ui': {
'labelStacking': 'vertical',
'allowTyping': true,
'allowMultiple': false
}
}
});
////////
// Define a full table
var fullTable = new google.visualization.ChartWrapper({
'chartType': 'Table',
'containerId': 'fulltable',
'options': {'width': '90em'}
});
var viewColumns = [0, 1, 2, 3, {
type: 'boolean',
role: 'certainty',
calc: function () {return false;}
}, 4, {
type: 'boolean',
role: 'certainty',
...