Dynamically plotting data with google chart

[lise.nicolas]

Hi Bubble Community,
I know a lot of person had face issue with dynamicly plotting their data and there is already a lot of question on the forum about it but I don’t even know where to start…
I have found the google code for a pie chart but I don’t know where to put it or how to filter my data…
I understand that I am really novice on the subject but if anyone could teach me how to use google chart and the external api, you would be a life saver…
Is there somebody who could teach me ?
Thank you in advance for your time…

[lise.nicolas]

Hey, Is there anyone who could give me a hand on that ? I’m still really block…

[lise.nicolas]

Hey Everyone,

Could someone please help me to plot dynamically my data?

I do know that i have to create an html box and use the following code :

google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart);

  function drawChart() {

    var data = google.visualization.arrayToDataTable([
      ['Task', ' Hours per Day'],
      ['work', 6  ],
      ['Eat',      2],
      ['Commute',  2],
      ['Watch TV', 2],
      ['Sleep',    7]
    ]);

    var options = {
      title: 'Statistiques'
    };

    var chart = new google.visualization.PieChart(document.getElementById('piechart'));

    chart.draw(data, options);
  }
</script>

But I don’t know how to change it to create a function that search and count what I want in my database…
Would anyone give me a hand on that ?

Thank you in advance for that, you would really be a life saver !