Sorry, my mistake, I left off a closing parenthesis on this line:
$temp[] = array('v' => "Date($year, $month, $day)";
it should be:
$temp[] = array('v' => "Date($year, $month, $day)");
On Monday, March 18, 2013 3:45:45 PM UTC-4, Ian Haylock wrote:
>
> thanks for your reply... i did the changes that you describe, but nothing,
> now i can´t see anything on the screen, before i could see the JSon data
> that i was echoing jsut to make sure i was getting the data from mysql... i
> checked for grammar errors and also the date format in mysql and it is
> YYYY-MM-DD so that is not the problem... any ideas what could be giving me
> trouble now ???
>
> On Monday, March 18, 2013 12:01:54 PM UTC-6, asgallant wrote:
>>
>> ATL charts require a "date" type domain column, while you are providing a
>> "string" type. You have to convert to a date type to make it work.
>> Assuming your dates are in the format "year-month-day", this is how you
>> would convert them to an API-compatible format:
>>
>> $table['cols'] = array(
>> array('label' => 'fecha', 'type' => 'date'),
>> array('label' => 'msnm', 'type' => 'number')
>> );
>>
>> $rows = array();
>> while($r = mysql_fetch_assoc($sth)) {
>> $temp = array();
>> $dateArr = explode('-', $r['fecha']);
>> $year = $dateArr[0];
>> $month = $dateArr[1] - 1; // months are zero-indexed
>> $day = $dateArr[2];
>> $temp[] = array('v' => "Date($year, $month, $day)";
>> $temp[] = array('v' => (float) $r['msnm']);
>> $rows[] = array('c' => $temp);
>> }
>>
>> On Monday, March 18, 2013 1:44:20 PM UTC-4, Ian Haylock wrote:
>>>
>>> Hi asgallant, can you help me with this please? .. im trying to display
>>> a annotatedtimeline chart but i have not been able too... when i try it on
>>> barchart, column chart or line chart it displays fine, but
>>> annotatedtimetimeline would not show .. this is what i have for
>>> annotatetimeline chart (further below is the linechart version which wroks
>>> fine):
>>>
>>> ***************************************************************************************************************************************************************
>>> $sth = mysql_query("select fecha, msnm from embalse, diarioembalse WHERE
>>> embalse_idembalse=idembalse and fecha between (select min(fecha) from
>>> diarioembalse) and (select max(fecha) from diarioembalse) order by fecha
>>> limit 0,31 ");
>>> //echo mysql_num_rows($sth);
>>> $rows = array();
>>> $flag = true;
>>>
>>> $table = array();
>>> $table['cols'] = array(
>>> array('label' => 'fecha', 'type' => 'string'),
>>> array('label' => 'msnm', 'type' => 'number')
>>> );
>>>
>>> $rows = array();
>>> while($r = mysql_fetch_assoc($sth)) {
>>> $temp = array();
>>> $temp[] = array('v' => (string)$r['fecha']);
>>> $temp[] = array('v' => (float) $r['msnm']);
>>> $rows[] = array('c' => $temp);
>>> }
>>>
>>> $table['rows'] = $rows;
>>>
>>> $jsonTable = json_encode($table);
>>>
>>> echo $jsonTable;
>>> ?>
>>>
>>> <script type="text/javascript">
>>> /*
>>> grafico de capacidad de plantas
>>> */
>>> google.load('visualization', '1', {'packages':['annotatedtimeline']});
>>> google.setOnLoadCallback(drawChart);
>>>
>>> function drawChart() {
>>> var data = new google.visualization.DataTable(<?php echo $jsonTable;
>>> ?>);
>>>
>>>
>>> var chart = new
>>> google.visualization.AnnotatedTimeLine(document.getElementById('chart_div'));
>>> chart.draw(data, {'displayAnnotations': true});
>>> }
>>>
>>> </script>
>>> <table>
>>> <tr>
>>> <td> <div id="chart_div" style="width: 700px; height: 500px;" ></div>
>>> </td>
>>> </tr>
>>>
>>> </table>
>>>
>>> *************************************************************************************************************************************
>>> the linechart version:
>>>
>>>
>>> $sth = mysql_query("select fecha, msnm from embalse, diarioembalse WHERE
>>> embalse_idembalse=idembalse and fecha between (select min(fecha) from
>>> diarioembalse) and (select max(fecha) from diarioembalse) order by fecha
>>> limit 0,31 ");
>>> //echo mysql_num_rows($sth);
>>> $rows = array();
>>> $flag = true;
>>>
>>> $table = array();
>>> $table['cols'] = array(
>>> array('label' => 'fecha', 'type' => 'string'),
>>> array('label' => 'msnm', 'type' => 'number')
>>> );
>>>
>>> $rows = array();
>>> while($r = mysql_fetch_assoc($sth)) {
>>> $temp = array();
>>> $temp[] = array('v' => (string)$r['fecha']);
>>> $temp[] = array('v' => (float) $r['msnm']);
>>> $rows[] = array('c' => $temp);
>>> }
>>>
>>> $table['rows'] = $rows;
>>>
>>> $jsonTable = json_encode($table);
>>>
>>> //echo $jsonTable;
>>> ?>
>>>
>>> <script type="text/javascript">
>>> /*
>>> grafico de capacidad de plantas
>>> */
>>> google.load('visualization', '1', {'packages':['corechart']});
>>> google.setOnLoadCallback(drawChart);
>>>
>>> function drawChart() {
>>> var data = new google.visualization.DataTable(<?php echo $jsonTable;
>>> ?>);
>>> var options = {'title':'nivel embalse',
>>> 'width':'1200',
>>> 'height':'800',
>>> 'chartArea':{'width':'70%','height':'80%'},
>>> 'backgroundColor':'transparent',
>>>
>>> };
>>>
>>> var chart = new
>>> google.visualization.LineChart(document.getElementById('chart_div'));
>>> chart.draw(data,options);
>>> }
>>>
>>>
>>>
>>> </script>
>>> <div id="chart_div" ></div>
>>>
>>> ***************************************************************************************************************
>>>
>>> what am i missing for the annotatedtimeline chart ??????
>>>
>>
--
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.
