<https://lh3.googleusercontent.com/-zYYQiyo7oj8/V3QNO4PV7PI/AAAAAAAACew/JQLYoewpyoIzyeYJ4KBf2vdUFy5-0kpSgCLcB/s1600/goog5.JPG>
<https://lh3.googleusercontent.com/-oEHGqMCQqGA/V3QAaMSi9BI/AAAAAAAACeg/rZyk2FmEscs9EtNvyPFhYr4kwcPeyunZACLcB/s1600/goog4.JPG> Hi Dan & Co.! Hope all are well! I too have just fallen victim to this bug that's going around, that is wreaking havoc with the chart displays: I saw this occur earlier in the year, over a weekend, but the following Monday it resolved on its own: Chalked it up to some update being run or such ...in that instance, 2016 was affected also, but this time it seems to be only 2014 and 2015: <https://lh3.googleusercontent.com/-3rg9UrjFB2o/V3P-eHUZn4I/AAAAAAAACd8/clzPhHuLX_Q8hkcLNtYu-1FSEauz-9z-gCLcB/s1600/goog.JPG> Zoom in 2014: No Feb Data: Feb Data intertwined with March <https://lh3.googleusercontent.com/-y-7U1gnE3w0/V3P-u-eMuEI/AAAAAAAACeE/Xc57QdGrbIsiV-EhK-glHIIrLs-NlxD6QCLcB/s1600/goog1.JPG> Zoom in 2015 : No Feb Data: Feb Data intertwined with March <https://lh3.googleusercontent.com/-4Aa77-CwflU/V3P-08NfdTI/AAAAAAAACeM/B5JD3bZr0NQkyfd9q9wT4XR8UmKuHs77ACLcB/s1600/goog2.JPG> Zoom in 2016, Normal <https://lh3.googleusercontent.com/-kT-peFluQsU/V3P-7Vde_cI/AAAAAAAACeU/atCfeMXcb0Qz8OUXvcJ_NfU1pITFtmVrQCLcB/s1600/goog3.JPG> Different Charts, Different MySQL Database. Same results: <https://lh3.googleusercontent.com/-oEHGqMCQqGA/V3QAaMSi9BI/AAAAAAAACeg/rZyk2FmEscs9EtNvyPFhYr4kwcPeyunZACLcB/s1600/goog4.JPG> Here's a basic mysql script - variable names changed to protect the innocent <?php include("conn.php"); $query="SELECT EXTRACT(YEAR FROM `date`) AS 'year', EXTRACT(MONTH FROM `date`) AS 'month', EXTRACT(DAY FROM `date`) AS 'day', `close`, `anot_code`, `alerts` FROM `mySQL_db_2014` WHERE `symbol`='MNKD' UNION ALL SELECT EXTRACT(YEAR FROM `date`) AS 'year', EXTRACT(MONTH FROM `date`) AS 'month', EXTRACT(DAY FROM `date`) AS 'day', `close`, `anot_code`, `alerts` FROM `mySQL_db_2015` WHERE `symbol`='MNKD' FROM `mySQL_db_2015` WHERE `symbol`='MNKD' UNION ALL SELECT EXTRACT(YEAR FROM `date`) AS 'year', EXTRACT(MONTH FROM `date`) AS 'month', EXTRACT(DAY FROM `date`) AS 'day', `close`, `anot_code`, `alerts` FROM `mySQL_db_2016` WHERE `symbol`='MNKD' ORDER BY `year` ASC, `month` ASC, `day` ASC"; $tabletr=array(); $table['cols']=array( array('label' => 'Date', 'type' => 'date','role' => 'domain'), array('label' => 'Close', 'type' => 'number', 'role' => 'data'), array('label' => '', 'type' =>'string', 'role' => 'annotation'), array('label' => '', 'type' =>'string', 'role' => 'annotationText') ); $table['rows']=$rows; $chartdata=mysql_query($query); while($r=mysql_fetch_assoc($chartdata)) { $temp=array(); $r['date']= array($r['year'], $r['month']-1, $r['day']); $r['date']=implode(",", $r[('date')]); $temp[]=array('v' =>"Date(".$r['date'].")"); $temp[]=array('v' => (float) $r['close']); $temp[]=array('v' => $r['anot_code']); $temp[]=array('v' => $r['alerts']); $rows[]=array('c' => $temp); }; $table['rows']=$rows; $jsondata=json_encode($table); echo $jsondata; ?> Use this link for resulting json data: better than sticking 3 years of data here: http://www.stockshortdata.com/functions/googtest.php ...but here's a screenshot of the 2014 return: Feb $ March highlighted: <https://lh3.googleusercontent.com/-zYYQiyo7oj8/V3QNO4PV7PI/AAAAAAAACew/JQLYoewpyoIzyeYJ4KBf2vdUFy5-0kpSgCLcB/s1600/goog5.JPG> ...and a chart script if you'd like: <script type='text/javascript'> google.load('visualization','1',{packages:['annotationchart']}); google.setOnLoadCallback(drawChrt); function drawChrt() { var data=new google.visualization.DataTable(<?=$jsonanot?>); var options={ title:'MNKD:Short Volume Alert Price Chart', width:'96%', height:'400', displayAnnotations:'true', displayAnnotationsFilter:'true' }; var chart =new google.visualization.AnnotationChart(document.getElementById( 'alerts_div')); chart.draw(data,options); }; </script> I recall reading that it may be a leap year issue, but as I mentioned, the problem resolved itself by the time I sat don to work that Monday... Any ideas and does this perhaps help isolate the bug? If the problem is on Google's end, and you want to troubleshoot it, the above charts can be located at the following pages: Annotation Chart: http://www.stockshortdata.com/ Line Chart: http://www.stockshortdata.com/dow/ If you can resolve it on your end again, you'll see it there when you do. Thanks in advance for any solution suggestions as well... Dom -- 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/4cd512a5-8bf1-4f22-9354-9606259b38b8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
