The
arrayToDataTable<https://developers.google.com/chart/interactive/docs/reference#google.visualization.arraytodatatable>method
doesn't handle dates properly; your dates are being input as
strings. To fix this, you will have to manually construct the DataTable
(or use the
json<https://developers.google.com/chart/interactive/docs/reference#dataparam>format).
Here's one way you could do it manually:
var obj = [
[new Date(2012,10,2),15,14],
//....
];
var data = new google.visualization.DataTable();
data.addColumn('date', 'Date');
data.addColumn('number', 'Buy');
data.addColumn('number', 'Sell');
data.addRows(obj);
Note that the format for the date is as a Date object and not a string when
using this method.
On Tuesday, November 27, 2012 5:37:44 AM UTC-5, Dragomir Haralambiev wrote:
>
> I'm trying to test the Google Chart, but I receive follow error:
> "One or more participants failed to draw().
> The filter cannot operate on a column of type string. Column type must be
> one of: number, date, datetime or timeofday. Column role must be domain,
> and correlate to a continuous axis."
>
> What am I doing wrong?
>
>
>
> <script type="text/javascript" src="https://www.google.com/jsapi";></script
> >
> <script type="text/javascript">
>
> google.load('visualization', '1.0', {'packages':['controls']});
> google.setOnLoadCallback(drawDashboard);
>
> function drawDashboard() {
> var obj =
> [["Date","buy","sell"],["Date(2012,10,2)",15,14],["Date(2012,10,3)",55,51],["Date(2012,10,4)",53,49]];
> var dataa = google.visualization.arrayToDataTable(obj);
> var dashboard = new
> google.visualization.Dashboard(document.getElementById('dashboard_div'));
>
> var donutRangeSlider = new google.visualization.ControlWrapper({
> 'controlType': 'ChartRangeFilter',
> 'containerId': 'filter_div',
> 'options': {
> 'filterColumnIndex': 0,
> 'ui': {
> 'chartType': 'LineChart',
> 'chartOptions': {
> 'chartArea': {'width': '90%'},
> 'hAxis': {'baselineColor': 'none'}
> },
> 'chartView': { 'columns': [0, 1] },
> 'minRangeSize': 86400000
> }
> },
> });
>
> var lineChart = new google.visualization.ChartWrapper({
> 'chartType': 'LineChart',
> 'containerId': 'chart_div',
> 'options': {
> title: 'Title',
> }
> });
>
> dashboard.bind(donutRangeSlider, lineChart);
> dashboard.draw(dataa);
> }
> </script>
>
> Best regards,
> Dragomir
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/NCH2nQYVMLwJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
