Folks, am at wits end with this one. Have read a lot of olderposts and
tried a bunch of things but cant seem to get a handle on this date related
error:
Object 2012-05-22 has no method 'getTimezoneOffset'
I retrieve data from mysql and create my json data as follows. The
date_sub function is moving the time from UTC to mytimezone. The dashboard
works fine with other controls so dont think that is a factor:
$result = mysql_query("SELECT prop_id as Property,
date_format(date_sub(datetime, interval 7 HOUR), '%Y-%m')as month,
date_format(date_sub(datetime, interval 7 HOUR), '%w-%a')as weekday,
date_format(date_sub(datetime, interval 7 HOUR), '%H')as hour, 1 as calls,
duration, scored, callercategory, answered, callsource, appointment,
date_format(date_sub(datetime, interval 7 HOUR), '%Y-%m-%d')as datetime
FROM leads_phone WHERE 1 ORDER BY datetime ASC");
$dataTable = array(
'cols' => array(
// each column needs an entry here, like this:
array('type' => 'string', 'label' => 'Property'),
array('type' => 'string', 'label' => 'month'),
array('type' => 'string', 'label' => 'weekday'),
array('type' => 'string', 'label' => 'hour'),
array('type' => 'number', 'label' => 'calls'),
array('type' => 'number', 'label' => 'duration'),
array('type' => 'string', 'label' => 'scored'),
array('type' => 'string', 'label' => 'callercategory'),
array('type' => 'string', 'label' => 'answered'),
array('type' => 'string', 'label' => 'callsource'),
array('type' => 'string', 'label' => 'appointment'),
array('type' => 'date', 'label' => 'datetime')
)
);
while($row=mysql_fetch_assoc($result)){
$dataTable['rows'][] = array(
'c' => array (
array('v' => $row['Property']),
array('v' => $row['month']),
array('v' => $row['weekday']),
array('v' => $row['hour']),
array('v' => (int) $row['calls']),
array('v' => (int) $row['duration']),
array('v' => $row['scored']),
array('v' => $row['callercategory']),
array('v' => $row['answered']),
array('v' => $row['callsource']),
array('v' => $row['appointment']),
array('v' => $row['datetime'])
)
);
}
$jsondata = json_encode($dataTable);
I have the following chartrangefilter as a control for various charts in my
dashboard:
var durationSlider = new google.visualization.ControlWrapper({
'controlType': 'ChartRangeFilter',
'containerId': 'duration_slider_div',
'options': {
// Filter by the date axis.
'filterColumnLabel': 'datetime',
'ui': {
'chartType': 'LineChart',
'chartOptions': {
'chartArea': {'width': '90%'},
'hAxis': {'baselineColor': 'none'}
},
'chartView': {
'columns': [11, 4]
},
// 1 day in milliseconds = 24 * 60 * 60 * 1000 = 86,400,000
'minRangeSize': 86400000
}
},
// Initial range: 2012-02-09 to 2012-03-20.
'state': {'range': {'start': new Date(2012, 5, 22), 'end': new
Date(2013, 2, 20)}}
});
I get the Object 2012-05-22 has no method 'getTimezoneOffset' error.
Also wanted to take the opportunity to thank Asgallant and others for all
your help on this and other groups. Your advise and guidance is invaluable.
Thanks!
Nikhil
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
