Table Chart Example

An example of a Google Table Chart.

HTML

<script src="https://www.google.com/jsapi?autoload={&#39;modules&#39;:[{&#39;name&#39;:&#39;visualization&#39;,&#39;version&#39;:&#39;1&#39;,&#39;packages&#39;:[&#39;table&#39;]}]}"></script>
<p>&nbsp;</p>
<br/><br/>

<div id="table_div"></div>

JavaScript

google.setOnLoadCallback(drawTable);

      function drawTable() {
        var data = new google.visualization.DataTable();
        data.addColumn('string', 'Name');
        data.addColumn('number', 'Salary');
        data.addColumn('string', 'Date');
        data.addRows([
          ['Mike',  {v: 10000, f: '$10,000'}, changeMe(2015, 04, 03, 13, 30)],
          ['Jim',   {v:8000,   f: '$8,000'},   changeMe(2015, 04, 03, 14, 00)],
          ['Alice', {v: 12500, f: '$12,500'},  changeMe(2015, 04, 03, 14, 30)]
        ]);
          
          var formatter = new google.visualization.DateFormat({pattern: "dd/mm/yyyy, HH:mm"});
formatter.format(data, 2);
        var table = new google.visualization.Table(document.getElementById('table_div'));

        table.draw(data, {showRowNumber: true, height: 360});
      }

function changeMe(year, month, day, hour, min){
   var dateObj = new Date(year, month, day, hour, min),  
    need_interval = `15`,
    interval_remaining = 0;

var hours = dateObj.getHours(),
    minutes = dateObj.getMinutes();
    if(minutes >= need_interval) {
    minutes = minutes - need_interval;
} else {
    interval_remaining  = need_interval - minutes;
    hours = hours - 1;
    minutes = minutes - interval_remaining;
    if (minutes < 0)
    {
      minutes = 60 + minutes;
    }
}
    var response = dateObj.getDate()+'/'+dateObj.getMonth()+'/'+dateObj.getFullYear()+', '+Math.abs(hours)+':'+addZero(minutes)+'-'+dateObj.getHours()+':'+addZero(dateObj.getMinutes());
    return response;
}

function addZero(value) {
    value = Math.abs(value);
    if(value.toString().length == 1){
        value += '0';        
    }
    return value;
}