Your data looks like only text. I'm not sure what you wanted to do, but if you want to use the text that follows numbers as annotations or tooltips, you need to put that text in a separate column. E.g. ['Carmo', 1.1, 'Visão Estratégica / Coerência']
On Tue, Jul 5, 2016 at 12:50 PM, Gil Carvalho <[email protected]> wrote: > Hi > I'm having problem getting my chart, the data is loaded but i have no chart > This is my code > > <div id="visualization" style="width: 800px; height: 400px;"> > <?php > $query = "SELECT COUNT(*) AS total FROM estatistica_atividades"; > $result =$DB_con->prepare($query); > $result->execute(); > $number_of_rows = $result->rowCount(); > if ($number_of_rows > 0) { > ?> > <script type="text/javascript" > src="http://www.google.com/jsapi";></script> > <script type="text/javascript"> > var google; > google.load('visualization', '1', {'packages': ['corechart', > 'geochart', 'table']}); > </script> > <script type="text/javascript"> > function drawVisualization() { > // Create and populate the data table. > var data = google.visualization.arrayToDataTable([ > ['Escola', 'Domínios'], > <?php > $graf = "SELECT escola.escola, dominios.dominio, > COUNT(*) AS total > FROM estatistica_atividades > JOIN escola ON > estatistica_atividades.id_escola = escola.id_escola > JOIN dominios ON > estatistica_atividades.id_dominios = dominios.id_dominio > GROUP BY escola.escola,dominios.dominio;"; > $resultado =$DB_con->prepare($graf); > $resultado->execute(); > $rows = $resultado->fetchALL(PDO::FETCH_ASSOC); > foreach ($rows as $row) { > extract($row); > echo "['{$escola}', '{$dominio}']"; > } > ?> > ]); > new > google.visualization.ColumnChart(document.getElementById('visualization')). > draw(data, {title: "Distribuição dos domínios por > escola"}); > } > google.setOnLoadCallback(drawVisualization); > </script> > <?php > } else { > echo "Sem atividades registadas"; > } > ?> > </div> > > > In the debugger i have this > > var data = google.visualization.arrayToDataTable([ > ['Escola', 'Domínios'], > ['Carmo', '1.1 - Visão Estratégica / > Coerência']['Carmo', '1.4 - Relações / Formas de Comunicação']['Carmo', > '2.2 Gestão dos recursos humanos']['Carmo', '3.1.1 Gestão > curricular']['Carmo', '5.2 Desenvolvimento pessoal e social']['Carmo', '5.4 > Valorização das aprendizagens']['Frei', '1.1 - Visão Estratégica / > Coerência']['Frei', '1.4 - Relações / Formas de Comunicação']['Frei', '2.2 > Gestão dos recursos humanos']['Frei', '3.1.1 Gestão curricular']['Frei', > '5.2 Desenvolvimento pessoal e social']['Frei', '5.4 Valorização das > aprendizagens']['Santa Maria Maior', '1.1 - Visão Estratégica / > Coerência']['Santa Maria Maior', '1.4 - Relações / Formas de > Comunicação']['Santa Maria Maior', '2.2 Gestão dos recursos > humanos']['Santa Maria Maior', '3.1.1 Gestão curricular']['Santa Maria > Maior', '5.2 Desenvolvimento pessoal e social']['Santa Maria Maior', '5.4 > Valorização das aprendizagens'] > > So my query is working.... > > any help? > > -- > 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/d777d47e-8c50-461e-8370-08da53e3d4f5%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/d777d47e-8c50-461e-8370-08da53e3d4f5%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- 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/CAOtcSJOGKxTb_AJPUBRnKxmCTUhcUMLZPzAd30sU4%3DsUVZx6ZA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
