[visualization-api] Convert unix time to date in a linechart

Tue, 03 Jun 2014 10:35:24 -0700 

I'm using JSON data to feed a line chart, and the first column is all unix 
timestamps.
Is there an easy way to have the chart automatically show those as readable 
dates instead of just the number of seconds?

here is my code as of now:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
  <title>KEGERATOR</title>
<link rel="stylesheet" type="text/css" href="style/style.css" 
media="screen" />
    <!-- Load jQuery -->
    <script language="javascript" type="text/javascript"
        
src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js";>
    </script>
    <!-- Load Google JSAPI -->
    <script type="text/javascript" 
src="https://www.google.com/jsapi";></script>
    <script type="text/javascript">
  $.ajaxSetup ({
      // Disable caching of AJAX responses */
    cache: false
        });
        google.load("visualization", "1", { packages: ["corechart"] });
        google.load('visualization', '1.0', {'packages':['controls']});

        google.setOnLoadCallback(drawChart);
        function drawChart() {
            var jsonData = $.ajax({
                url: "chartselect.php?limit=<?php echo $limit;?>&s1=<?php 
echo $s1;?>&s2=<?php echo $s2;?>&s3=<?php echo $s3;?>&s4=<?php echo 
$s4;?>&s5=<?ph\
p echo $s5?>&s6=<?php echo $s6?><?php if ($res) echo '&res='.$res?>",
                dataType: "json",
                async: false
            }).responseText;

            var obj = jQuery.parseJSON(jsonData);
  var data = google.visualization.arrayToDataTable(obj);

            var chart = new google.visualization.ChartWrapper({
              chartType: 'LineChart',
                  containerId: 'chart_div',
                  options: {

                chartArea: {
                  left: '0%',
                      width: '100%',
                      top: '0%',
                      height: '100%'
                      },
                    theme: 'maximized'

                    }});

            var control = new google.visualization.ControlWrapper({
              controlType: 'ChartRangeFilter',
                  containerId: 'control_div',
                  options: {
                filterColumnIndex: 0, //set the column index to filter on 
here
                    ui: {
                  chartOptions: {

                    chartArea: {
                      left: '0%',
                          width: '100%',
                          top: '10%',
                          height: '100%'
                          },

                    }
                  }
                }
              });

            var dashboard = new 
google.visualization.Dashboard(document.querySelector('#dashboard'));
            dashboard.bind([control], [chart]);
            dashboard.draw(data);

        }


-- 
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/d/optout.

Reply via email to