OBIEE Google Charts part 2

Impress with real venn diagrams:

First get your data:

add an extra column with a row count:

Hide it:

add an narrative view:

<img src="" id="venn_chart@9"/>  <!-- creates an unique img tag -->
<script type="text/javascript">
var chartURL = "http://chart.apis.google.com/chart?cht=v&chs=200x200&chd=t:@2,@3,@4,@5,@6,@7,@8&chtt=@1&chdl=a|b|c&chdlp=b" ;
/* cht = chart type
   chs = chart size
  chd = chart data
  chtt = chart title
  chdl = chart legend
  chdlp= chart legend position
  more info http://code.google.com/intl/nl/apis/chart/ */

/* get the chart */
document.getElementById('venn_chart@9').src = chartURL;
</script>

 

Put all together:

Till Next Time

This article is also published on http://knowledge.ciber.nl