GOOGLE LINE CHART ERROR: All series on a given axis must be of the same data type. EMPTY QUERY

up vote
1
down vote

favorite

i've a problem with a line chart which displays the error "All series on a given axis must be of the same data type" when a query gives null result or no rows.

If you look carefully there are 7 queries (everyone draw a line on the same chart), if any query gives back an empty result (no rows) i get the error in the topic title. When all queries are not empty, chart correctly works.

Is there a way to avoid this error ?

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>

<html>

     <head>

    <!--Load the AJAX API-->

    <script type="text/javascript" src="https://www.google.com/jsapi"> 

    </script>

    <script type="text/javascript">



      // Load the Visualization API and the piechart package.

      google.load('visualization', '1.0', {'packages':['corechart']});



      // Set a callback to run when the Google Visualization API is loaded.

      google.setOnLoadCallback(drawChart);



      // Callback that creates and populates a data table,

      // instantiates the pie chart, passes in the data and

      // draws it.

      function drawChart() {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates





var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(joinedData6, {

    height: 500,

    width: 1400,

    interpolateNulls: true,



});

}



google.load('visualization', '1', {packages:['corechart'], callback: drawChart});

    </script>

  </head>



  <body><br /><br />  

       <div style="width:1500px;" align="center">  

                <h1 align="center" style="font-size:22px">Produzione SMARTEASY: MYENNOVA (Ultimi 10 Mesi)</h1>  

            <br />  

            <div align="center" id="piechart2" style="float:left; width: 700px; height: 390px;"></div> 

            <div align="center" id="piechart1" style="float:left; width: 700px; height: 390px;"></div>   

       </div>

    <!--Divs that will hold the charts-->

    <div id="chart_div"></div>



  </body>

</html>

edited Nov 14 at 17:22

WhiteHat

35.3k61375

asked Nov 14 at 16:37

Francesco Minniti

113

add a comment |

up vote
1
down vote

favorite

i've a problem with a line chart which displays the error "All series on a given axis must be of the same data type" when a query gives null result or no rows.

Is there a way to avoid this error ?

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>

<html>

     <head>

    <!--Load the AJAX API-->

    <script type="text/javascript" src="https://www.google.com/jsapi"> 

    </script>

    <script type="text/javascript">



      // Load the Visualization API and the piechart package.

      google.load('visualization', '1.0', {'packages':['corechart']});



      // Set a callback to run when the Google Visualization API is loaded.

      google.setOnLoadCallback(drawChart);



      // Callback that creates and populates a data table,

      // instantiates the pie chart, passes in the data and

      // draws it.

      function drawChart() {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates





var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(joinedData6, {

    height: 500,

    width: 1400,

    interpolateNulls: true,



});

}



google.load('visualization', '1', {packages:['corechart'], callback: drawChart});

    </script>

  </head>



  <body><br /><br />  

       <div style="width:1500px;" align="center">  

                <h1 align="center" style="font-size:22px">Produzione SMARTEASY: MYENNOVA (Ultimi 10 Mesi)</h1>  

            <br />  

            <div align="center" id="piechart2" style="float:left; width: 700px; height: 390px;"></div> 

            <div align="center" id="piechart1" style="float:left; width: 700px; height: 390px;"></div>   

       </div>

    <!--Divs that will hold the charts-->

    <div id="chart_div"></div>



  </body>

</html>

edited Nov 14 at 17:22

WhiteHat

35.3k61375

asked Nov 14 at 16:37

Francesco Minniti

113

add a comment |

up vote
1
down vote

favorite

i've a problem with a line chart which displays the error "All series on a given axis must be of the same data type" when a query gives null result or no rows.

Is there a way to avoid this error ?

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>

<html>

     <head>

    <!--Load the AJAX API-->

    <script type="text/javascript" src="https://www.google.com/jsapi"> 

    </script>

    <script type="text/javascript">



      // Load the Visualization API and the piechart package.

      google.load('visualization', '1.0', {'packages':['corechart']});



      // Set a callback to run when the Google Visualization API is loaded.

      google.setOnLoadCallback(drawChart);



      // Callback that creates and populates a data table,

      // instantiates the pie chart, passes in the data and

      // draws it.

      function drawChart() {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates





var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(joinedData6, {

    height: 500,

    width: 1400,

    interpolateNulls: true,



});

}



google.load('visualization', '1', {packages:['corechart'], callback: drawChart});

    </script>

  </head>



  <body><br /><br />  

       <div style="width:1500px;" align="center">  

                <h1 align="center" style="font-size:22px">Produzione SMARTEASY: MYENNOVA (Ultimi 10 Mesi)</h1>  

            <br />  

            <div align="center" id="piechart2" style="float:left; width: 700px; height: 390px;"></div> 

            <div align="center" id="piechart1" style="float:left; width: 700px; height: 390px;"></div>   

       </div>

    <!--Divs that will hold the charts-->

    <div id="chart_div"></div>



  </body>

</html>

edited Nov 14 at 17:22

WhiteHat

35.3k61375

asked Nov 14 at 16:37

Francesco Minniti

113

i've a problem with a line chart which displays the error "All series on a given axis must be of the same data type" when a query gives null result or no rows.

Is there a way to avoid this error ?

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>

<html>

     <head>

    <!--Load the AJAX API-->

    <script type="text/javascript" src="https://www.google.com/jsapi"> 

    </script>

    <script type="text/javascript">



      // Load the Visualization API and the piechart package.

      google.load('visualization', '1.0', {'packages':['corechart']});



      // Set a callback to run when the Google Visualization API is loaded.

      google.setOnLoadCallback(drawChart);



      // Callback that creates and populates a data table,

      // instantiates the pie chart, passes in the data and

      // draws it.

      function drawChart() {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates





var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(joinedData6, {

    height: 500,

    width: 1400,

    interpolateNulls: true,



});

}



google.load('visualization', '1', {packages:['corechart'], callback: drawChart});

    </script>

  </head>



  <body><br /><br />  

       <div style="width:1500px;" align="center">  

                <h1 align="center" style="font-size:22px">Produzione SMARTEASY: MYENNOVA (Ultimi 10 Mesi)</h1>  

            <br />  

            <div align="center" id="piechart2" style="float:left; width: 700px; height: 390px;"></div> 

            <div align="center" id="piechart1" style="float:left; width: 700px; height: 390px;"></div>   

       </div>

    <!--Divs that will hold the charts-->

    <div id="chart_div"></div>



  </body>

</html>

charts google-visualization line

edited Nov 14 at 17:22

WhiteHat

35.3k61375

asked Nov 14 at 16:37

Francesco Minniti

113

edited Nov 14 at 17:22

WhiteHat

35.3k61375

asked Nov 14 at 16:37

Francesco Minniti

113

edited Nov 14 at 17:22

WhiteHat

35.3k61375

edited Nov 14 at 17:22

WhiteHat

35.3k61375

edited Nov 14 at 17:22

WhiteHat

35.3k61375

asked Nov 14 at 16:37

Francesco Minniti

113

asked Nov 14 at 16:37

Francesco Minniti

113

asked Nov 14 at 16:37

Francesco Minniti

113

add a comment |

2 Answers
2

active

oldest

votes

up vote
0
down vote

accepted

you could use a data view to draw the chart,

and only include columns from the joined data that have values.

using data table method getColumnRange,

we can determine if the column has data.

columns that don't have data,
getColumnRange will return null for both min & max

// build view columns

var viewColumns = ;

for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

  var range = joinedData6.getColumnRange(i);



  // determine if column has values

  if (!((range.min === null) && (range.min === null))) {

    viewColumns.push(i);

  }

}



// build data view

var view = new google.visualization.DataView(joinedData6);

view.setColumns(viewColumns);



var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(view, {  // <-- use view to draw chart

  height: 500,

  width: 1400,

  interpolateNulls: true,

});

see following working snippet for an example...

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

edited Nov 14 at 18:50

answered Nov 14 at 18:35

WhiteHat

35.3k61375

I'm trying to adapt your example script on mine. But i've some difficulty cause i dont know but seems some tag is missing. I've completely removed the final part of my script, putting your inside. But at the beginning of the page need I to remove what ? I'll add what i've done.
– Francesco Minniti
Nov 15 at 11:36

https://www.google.com/jsapi is old and no longer needed...
– WhiteHat
Nov 15 at 12:31

add a comment |

up vote
0
down vote

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>



    <!--Load the AJAX API-->

    <script src="https://www.gstatic.com/charts/loader.js"></script>

    <script type="text/javascript" src="https://www.google.com/jsapi"></script>

    <script type="text/javascript">



      google.charts.load('current', {

      packages: ['corechart']

      }).then(function () {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates



    // build view columns

   var viewColumns = ;

   for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

   var range = joinedData6.getColumnRange(i);



// determine if column has values

if ((range.min !== null) || (range.max !== null)) {

  viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

height: 500,

width: 1400,

interpolateNulls: true,

  });

 });

answered Nov 15 at 11:45

Francesco Minniti

113

MAYBE DID IT :) Eliminating from Database the 0 rows :)
– Francesco Minniti
Nov 15 at 11:53

DID IT !!!! Thank you very much Whitehat.
– Francesco Minniti
Nov 15 at 13:38

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53304906%2fgoogle-line-chart-error-all-series-on-a-given-axis-must-be-of-the-same-data-typ%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
0
down vote

accepted

you could use a data view to draw the chart,

and only include columns from the joined data that have values.

using data table method getColumnRange,

we can determine if the column has data.

columns that don't have data,
getColumnRange will return null for both min & max

// build view columns

var viewColumns = ;

for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

  var range = joinedData6.getColumnRange(i);



  // determine if column has values

  if (!((range.min === null) && (range.min === null))) {

    viewColumns.push(i);

  }

}



// build data view

var view = new google.visualization.DataView(joinedData6);

view.setColumns(viewColumns);



var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(view, {  // <-- use view to draw chart

  height: 500,

  width: 1400,

  interpolateNulls: true,

});

see following working snippet for an example...

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

edited Nov 14 at 18:50

answered Nov 14 at 18:35

WhiteHat

35.3k61375

I'm trying to adapt your example script on mine. But i've some difficulty cause i dont know but seems some tag is missing. I've completely removed the final part of my script, putting your inside. But at the beginning of the page need I to remove what ? I'll add what i've done.
– Francesco Minniti
Nov 15 at 11:36

https://www.google.com/jsapi is old and no longer needed...
– WhiteHat
Nov 15 at 12:31

add a comment |

up vote
0
down vote

accepted

you could use a data view to draw the chart,

and only include columns from the joined data that have values.

using data table method getColumnRange,

we can determine if the column has data.

columns that don't have data,
getColumnRange will return null for both min & max

// build view columns

var viewColumns = ;

for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

  var range = joinedData6.getColumnRange(i);



  // determine if column has values

  if (!((range.min === null) && (range.min === null))) {

    viewColumns.push(i);

  }

}



// build data view

var view = new google.visualization.DataView(joinedData6);

view.setColumns(viewColumns);



var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(view, {  // <-- use view to draw chart

  height: 500,

  width: 1400,

  interpolateNulls: true,

});

see following working snippet for an example...

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

edited Nov 14 at 18:50

answered Nov 14 at 18:35

WhiteHat

35.3k61375

I'm trying to adapt your example script on mine. But i've some difficulty cause i dont know but seems some tag is missing. I've completely removed the final part of my script, putting your inside. But at the beginning of the page need I to remove what ? I'll add what i've done.
– Francesco Minniti
Nov 15 at 11:36

https://www.google.com/jsapi is old and no longer needed...
– WhiteHat
Nov 15 at 12:31

add a comment |

up vote
0
down vote

accepted

you could use a data view to draw the chart,

and only include columns from the joined data that have values.

using data table method getColumnRange,

we can determine if the column has data.

columns that don't have data,
getColumnRange will return null for both min & max

// build view columns

var viewColumns = ;

for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

  var range = joinedData6.getColumnRange(i);



  // determine if column has values

  if (!((range.min === null) && (range.min === null))) {

    viewColumns.push(i);

  }

}



// build data view

var view = new google.visualization.DataView(joinedData6);

view.setColumns(viewColumns);



var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(view, {  // <-- use view to draw chart

  height: 500,

  width: 1400,

  interpolateNulls: true,

});

see following working snippet for an example...

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

edited Nov 14 at 18:50

answered Nov 14 at 18:35

WhiteHat

35.3k61375

you could use a data view to draw the chart,

and only include columns from the joined data that have values.

using data table method getColumnRange,

we can determine if the column has data.

columns that don't have data,
getColumnRange will return null for both min & max

// build view columns

var viewColumns = ;

for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

  var range = joinedData6.getColumnRange(i);



  // determine if column has values

  if (!((range.min === null) && (range.min === null))) {

    viewColumns.push(i);

  }

}



// build data view

var view = new google.visualization.DataView(joinedData6);

view.setColumns(viewColumns);



var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

chart.draw(view, {  // <-- use view to draw chart

  height: 500,

  width: 1400,

  interpolateNulls: true,

});

see following working snippet for an example...

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

google.charts.load('current', {

  packages: ['corechart']

}).then(function () {

  var data1 = google.visualization.arrayToDataTable([

    ['Date', 'LaMotta'],

    ['test1', 5],

    ['test1', 6],

    ['test1', 7],

  ]);



  var data2 = google.visualization.arrayToDataTable([

    ['Date', 'Spadone'],

  ]);



  var data3 = google.visualization.arrayToDataTable([

    ['Date', 'Ivo'],

    ['test3', 8],

    ['test3', 9],

    ['test3', 0],

  ]);



  var data4 = google.visualization.arrayToDataTable([

    ['Date', 'Montagliani'],

  ]);



  var data5 = google.visualization.arrayToDataTable([

    ['Date', 'Galtieri'],

    ['test5', 1],

    ['test5', 2],

    ['test5', 3],

  ]);



  var data6 = google.visualization.arrayToDataTable([

    ['Date', 'Giacometti'],

  ]);



  var data7 = google.visualization.arrayToDataTable([

    ['Date', 'Mantovani'],

    ['test7', 4],

    ['test7', 5],

    ['test7', 6],

  ]);



  var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

  var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

  var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

  var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

  var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

  var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



  // build view columns

  var viewColumns = ;

  for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

    var range = joinedData6.getColumnRange(i);



    // determine if column has values

    if ((range.min !== null) || (range.max !== null)) {

      viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

    height: 500,

    width: 1400,

    interpolateNulls: true,

  });

});

<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="chart_div"></div>

edited Nov 14 at 18:50

answered Nov 14 at 18:35

WhiteHat

35.3k61375

edited Nov 14 at 18:50

answered Nov 14 at 18:35

WhiteHat

35.3k61375

answered Nov 14 at 18:35

WhiteHat

35.3k61375

answered Nov 14 at 18:35

WhiteHat

35.3k61375

I'm trying to adapt your example script on mine. But i've some difficulty cause i dont know but seems some tag is missing. I've completely removed the final part of my script, putting your inside. But at the beginning of the page need I to remove what ? I'll add what i've done.
– Francesco Minniti
Nov 15 at 11:36

https://www.google.com/jsapi is old and no longer needed...
– WhiteHat
Nov 15 at 12:31

add a comment |

I'm trying to adapt your example script on mine. But i've some difficulty cause i dont know but seems some tag is missing. I've completely removed the final part of my script, putting your inside. But at the beginning of the page need I to remove what ? I'll add what i've done.
– Francesco Minniti
Nov 15 at 11:36

https://www.google.com/jsapi is old and no longer needed...
– WhiteHat
Nov 15 at 12:31

I'm trying to adapt your example script on mine. But i've some difficulty cause i dont know but seems some tag is missing. I've completely removed the final part of my script, putting your inside. But at the beginning of the page need I to remove what ? I'll add what i've done.
– Francesco Minniti
Nov 15 at 11:36

https://www.google.com/jsapi is old and no longer needed...
– WhiteHat
Nov 15 at 12:31

add a comment |

up vote
0
down vote

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>



    <!--Load the AJAX API-->

    <script src="https://www.gstatic.com/charts/loader.js"></script>

    <script type="text/javascript" src="https://www.google.com/jsapi"></script>

    <script type="text/javascript">



      google.charts.load('current', {

      packages: ['corechart']

      }).then(function () {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates



    // build view columns

   var viewColumns = ;

   for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

   var range = joinedData6.getColumnRange(i);



// determine if column has values

if ((range.min !== null) || (range.max !== null)) {

  viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

height: 500,

width: 1400,

interpolateNulls: true,

  });

 });

answered Nov 15 at 11:45

Francesco Minniti

113

MAYBE DID IT :) Eliminating from Database the 0 rows :)
– Francesco Minniti
Nov 15 at 11:53

DID IT !!!! Thank you very much Whitehat.
– Francesco Minniti
Nov 15 at 13:38

add a comment |

up vote
0
down vote

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>



    <!--Load the AJAX API-->

    <script src="https://www.gstatic.com/charts/loader.js"></script>

    <script type="text/javascript" src="https://www.google.com/jsapi"></script>

    <script type="text/javascript">



      google.charts.load('current', {

      packages: ['corechart']

      }).then(function () {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates



    // build view columns

   var viewColumns = ;

   for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

   var range = joinedData6.getColumnRange(i);



// determine if column has values

if ((range.min !== null) || (range.max !== null)) {

  viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

height: 500,

width: 1400,

interpolateNulls: true,

  });

 });

answered Nov 15 at 11:45

Francesco Minniti

113

MAYBE DID IT :) Eliminating from Database the 0 rows :)
– Francesco Minniti
Nov 15 at 11:53

DID IT !!!! Thank you very much Whitehat.
– Francesco Minniti
Nov 15 at 13:38

add a comment |

up vote
0
down vote

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>



    <!--Load the AJAX API-->

    <script src="https://www.gstatic.com/charts/loader.js"></script>

    <script type="text/javascript" src="https://www.google.com/jsapi"></script>

    <script type="text/javascript">



      google.charts.load('current', {

      packages: ['corechart']

      }).then(function () {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates



    // build view columns

   var viewColumns = ;

   for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

   var range = joinedData6.getColumnRange(i);



// determine if column has values

if ((range.min !== null) || (range.max !== null)) {

  viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

height: 500,

width: 1400,

interpolateNulls: true,

  });

 });

answered Nov 15 at 11:45

Francesco Minniti

113

<?php

$curyear = date('Y');

 $con = mysqli_connect('xxx','xxx','xxx','xxx');

?>



    <!--Load the AJAX API-->

    <script src="https://www.gstatic.com/charts/loader.js"></script>

    <script type="text/javascript" src="https://www.google.com/jsapi"></script>

    <script type="text/javascript">



      google.charts.load('current', {

      packages: ['corechart']

      }).then(function () {

var data1 = google.visualization.arrayToDataTable([

        ['Date', 'LaMotta'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as LaMotta, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ01' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['LaMotta']."],";





         }

        ?> 



       ]);



var data2 = google.visualization.arrayToDataTable([

        ['Date', 'Spadone'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Spadone, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ02' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Spadone']."],";



         }

        ?> 



       ]);



var data3 = google.visualization.arrayToDataTable([

        ['Date', 'Ivo'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Ivo, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ11' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Ivo']."],";





         }

        ?> 



       ]);





 var data4 = google.visualization.arrayToDataTable([

        ['Date', 'Montagliani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Montagliani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ12' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Montagliani']."],";





         }

        ?> 



       ]);



  var data5 = google.visualization.arrayToDataTable([

        ['Date', 'Galtieri'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Galtieri, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ21' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Galtieri']."],";





         }

        ?> 



       ]);





  var data6 = google.visualization.arrayToDataTable([

        ['Date', 'Giacometti'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Giacometti, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ22' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Giacometti']."],";





         }

        ?> 



       ]);





  var data7 = google.visualization.arrayToDataTable([

        ['Date', 'Mantovani'],

         <?php 

            $query = "SELECT responsabile, sum(val_fattu) as Mantovani, data_dichiarato FROM dichiarati_myennova WHERE responsabile = 'ADMRZ23' and dichiarati_myennova.DATA_DICHIARATO > (NOW() - INTERVAL 270 DAY) GROUP BY MONTH(data_dichiarato), responsabile ORDER BY data_dichiarato";

            $exec = mysqli_query($con,$query);

            while($row = mysqli_fetch_array($exec)){



            echo "['".date("Y/m", strtotime($row['data_dichiarato']))."',".$row['Mantovani']."],";





         }

        ?> 



       ]);







var joinedData = google.visualization.data.join(data1, data2, 'full', [[0, 0]], [1], [1]);

var joinedData2 = google.visualization.data.join(joinedData, data3, 'full', [[0, 0]], [1,2], [1]);

var joinedData3 = google.visualization.data.join(joinedData2, data4, 'full', [[0, 0, 0]], [1,2,3], [1]);

var joinedData4 = google.visualization.data.join(joinedData3, data5, 'full', [[0, 0, 0, 0]], [1,2,3,4], [1]);

var joinedData5 = google.visualization.data.join(joinedData4, data6, 'full', [[0, 0, 0, 0, 0]], [1,2,3,4,5], [1]);

var joinedData6 = google.visualization.data.join(joinedData5, data7, 'full', [[0, 0, 0, 0, 0, 0]], [1,2,3,4,5,6], [1]);



// sort by start and end dates



    // build view columns

   var viewColumns = ;

   for (var i = 0; i < joinedData6.getNumberOfColumns(); i++) {

   var range = joinedData6.getColumnRange(i);



// determine if column has values

if ((range.min !== null) || (range.max !== null)) {

  viewColumns.push(i);

    }

  }



  // build data view

  var view = new google.visualization.DataView(joinedData6);

  view.setColumns(viewColumns);



  var chart = new google.visualization.LineChart(document.querySelector('#chart_div'));

  chart.draw(view, {  // <-- use view to draw chart

height: 500,

width: 1400,

interpolateNulls: true,

  });

 });

answered Nov 15 at 11:45

Francesco Minniti

113

answered Nov 15 at 11:45

Francesco Minniti

113

answered Nov 15 at 11:45

Francesco Minniti

113

answered Nov 15 at 11:45

Francesco Minniti

113

MAYBE DID IT :) Eliminating from Database the 0 rows :)
– Francesco Minniti
Nov 15 at 11:53

DID IT !!!! Thank you very much Whitehat.
– Francesco Minniti
Nov 15 at 13:38

add a comment |

MAYBE DID IT :) Eliminating from Database the 0 rows :)
– Francesco Minniti
Nov 15 at 11:53

DID IT !!!! Thank you very much Whitehat.
– Francesco Minniti
Nov 15 at 13:38

MAYBE DID IT :) Eliminating from Database the 0 rows :)
– Francesco Minniti
Nov 15 at 11:53

DID IT !!!! Thank you very much Whitehat.
– Francesco Minniti
Nov 15 at 13:38

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky