Hello all-
I'm working on a scatter chart that plots the hour of day on the vAxis and
day of the week on the hAxis. To do this, I needed to use the numeric
versions of those items (0-24 for hours, 0-6 for days). But for display
purposes, I'd like to do proper times for the hours (0=12am, 12=12pm,
13=1pm, etc.) and days (0=Sunday, etc.).
Can anyone offer guidance on how to do this? Using a formatter or running
some code to change formatted values does change how the plotted value
appears in the tooltip, but it does not change the labels on the axis.
Here's the basic code I am working with:
var data,chart;
function drawVisualization() {
var dates=[
[new Date(Date.parse('March 13, 2013 5:00 AM')),1,'Survey #1'],
[new Date(Date.parse('March 14, 2013 5:00 AM')),1,'Survey #2'],
[new Date(Date.parse('March 15, 2013 7:00 AM')),0,'Survey #3'],
[new Date(Date.parse('March 18, 2013 6:00 PM')),1,'Survey #2']
];
data = new google.visualization.DataTable();
data.addColumn('number', 'Day of Week');
data.addColumn('number', 'Success');
data.addColumn('number', 'Failure');
for(var i=0;i<dates.length;i++) {
var dt=dates[i];
var day=dt[0].getDay()+1;
var hour=dt[0].getHours();
if (dt[1]==1) data.addRow([day,hour,null]);
else data.addRow([day,null,hour]);
};
// Format data
for(var i=0;i<data.getNumberOfRows();i++){
var hour=data.getValue(i,0);
data.setFormattedValue(i,0,hour+'AM');
}
// Create and draw the visualization.
chart = new
google.visualization.ScatterChart(document.getElementById('chart_div'));
var options = {
title: 'Contact Success',
colors: ['#00FF00','#FF0000'],
hAxis: {title: 'Day of Week', minValue:1, maxValue:7, gridlines: { count: 7
} },
vAxis: {title: 'Hour of Day', minValue:0, maxValue:24 }
};
chart.draw(data, options);
}
Thanks in advance for any ideas you may have.
--
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.
