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]> 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]. > 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. > -- 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.
