It is possible to group data with the Visualization API (see the google.visualization.data.group <https://developers.google.com/chart/interactive/docs/reference#google_visualization_data_group> function), but this is probably easier to handle server-side, especially if you are using a SQL query to get the data.
On Tuesday, June 10, 2014 2:34:41 PM UTC-4, serene wrote: > > Hi Andrew thanks for you quick response. I tried to do that. Also, is > there a way to group by a field. e.g; I want to group the data in Row @1 by > dept, is it possible to define it in the narrative. > > I think, for each and every person the code is taking the value,... if you > see above, instead, can i define to just group by dept and take the values > for each dept? Please let me know if you got my question > > > On Tue, Jun 10, 2014 at 11:29 AM, Andrew Gallant <[email protected] > <javascript:>> wrote: > >> " " is not valid in javascript. Replace all of them with numbers, >> strings, or nulls as appropriate. >> >> >> On Tuesday, June 10, 2014 2:14:39 PM UTC-4, serene wrote: >>> >>> Hi I m trying to implement google bubble chart in my OBIEE. >>> >>> Here's my code: >>> >>> if(document.URL.indexOf("saw.dll?Answers") == -1) >>> {google.load("visualization", "1", >>> {packages:["corechart"]});google.setOnLoadCallback(drawChart);} >>> function drawChart() {if(document.URL.indexOf("saw.dll?Answers") == -1) { >>> // Create and populate the data table. var data = new >>> google.visualization.DataTable(); data.addColumn('string', >>> 'Department'); data.addColumn('number', 'Average'); >>> data.addColumn('number', 'Percent FY Benchmarks Achieved'); >>> data.addColumn('string', 'Buckets'); data.addColumn('number', >>> 'FYTD Actuals'); var myArray=[];myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', 0.000, parseFloat('150'), ('Above 150'), >>> 1037]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> , parseFloat('150'), ('Above 150'), >>> 94]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 2026]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 2671]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 437]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 1746]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.750, parseFloat('150'), ('Above 150'), >>> 4021]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.500, parseFloat('150'), ('Above 150'), >>> 1887]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> , parseFloat('150'), ('Above 150'), >>> 0]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', 0.000, >>> parseFloat('150'), ('Above 150'), 4587]);myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', 0.000, parseFloat('150'), ('Above 150'), >>> 4430]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> , parseFloat('150'), ('Above 150'), >>> 0]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', 0.000, >>> parseFloat('150'), ('Above 150'), 1132]);myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', 0.000, parseFloat('150'), ('Above 150'), >>> 0]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', 0.000, >>> parseFloat('150'), ('Above 150'), 2457]);myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', , parseFloat('150'), ('Above 150'), >>> 0]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', 0.000, >>> parseFloat('150'), ('Above 150'), 1209]);myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', 0.000, parseFloat('150'), ('Above 150'), >>> 1095]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 683]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), 0]);myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', 0.000, parseFloat('150'), ('Above 150'), >>> 2523]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 513]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 1.000, parseFloat('150'), ('Above 150'), >>> 2563]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 3253]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), 0]);myArray.push(['Anesthesiology, >>> Perioperative and Pain Medicine', 0.000, parseFloat('150'), ('Above 150'), >>> 2651]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 3177]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.000, parseFloat('150'), ('Above 150'), >>> 3039]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> 0.230, parseFloat('150'), ('Above 150'), >>> 2305]);myArray.push(['Anesthesiology, Perioperative and Pain Medicine', >>> , parseFloat('150'), ('Above 150'), >>> 0]);if(document.URL.indexOf("saw.dll?Answers") == -1) >>> {data.addRows(myArray); var chart = new >>> google.visualization.BubbleChart(document.getElementById('chart_div'));var >>> options = { title: 'Department', hAxis: {title: >>> 'Average', gridlines: {color: 'transparent'}}, vAxis: {title: >>> 'Percentage FY Benchmark Achieved'}, bubble: {textStyle: >>> {fontSize: 11}}, displayMode: 'markers' }; var chart >>> = new >>> google.visualization.BubbleChart(document.getElementById('chart_div')); >>> chart.draw(data, options); }}} >>> >>> >>> If you notice the rows pushed are just one. I have more that 20 row in >>> my database, however, just one gets pushed. And when it is pushed with >>>  , the graph doesnt plot. How can I fix this issue? >>> >>> Please suggest. >>> >>> Thanks, >>> >> -- >> 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] >> <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at >> http://groups.google.com/group/google-visualization-api. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
