getDataTable

//Takes a data range from GAS spreadsheet and a count on the number of charts wanted 
//then transitions it to a datatable while maintaining column '0' as a Date stamp. 

function getDataTable(chartData, counter){
  var dataTable = Charts.newDataTable();
  
  for (var col=0; col<counter+1; col++) {
    var label = chartData[0][col];
    var firstCell = chartData[1][col];
        
    if (col == 0)
      dataTable.addColumn(Charts.ColumnType.DATE, label);
    else if (typeof firstCell == 'number')
      dataTable.addColumn(Charts.ColumnType.NUMBER, label);
    else
      dataTable.addColumn(Charts.ColumnType.STRING, label);      
  }
  
  for (var row = 1; row < chartData.length; row++) {
    if (chartData[row][0] != ""){
      dataTable.addRow(chartData[row]);
    }
  }  
  var dt = dataTable.build()
  return dt; 
}