[[PageOutline(2-5,Contents,pullout)]]

= Embed Google Charts in wiki pages

== Description

This plugin provides a simple way to chart the result of an SQL query using the [https://developers.google.com/chart/?hl=en Google Chart API]. It defines a macro called GChart that can be used to pass variables into for the creation of charts, which are subsequently displayed on your wiki page.

=== Line chart

{{{
[[GChart(query="SELECT id FROM ticket", type="line")]]
}}}

{{{
#!html
<img src="http://chart.apis.google.com/chart?chd=t:30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0&chs=300x150&cht=lc" >
}}}

'''Note''': the following example macros must be entered in a single line.

=== Pie chart

{{{
[[GChart(type="pie", chs="250x100", query="SELECT rev FROM revision")]]
}}}

{{{
#!html
<img src="http://chart.apis.google.com/chart?chd=t:1.0,2.0,3.0,4.0&chs=250x100&cht=p" >
}}}

=== Add a legend

{{{
[[GChart(chxt="y", chco="ff0000,00ff00,0000ff", chs="300x150", type="lc", 
         chdl="Animals|Vegetables|Minerals", 
         query="SELECT rev, (10+2*rev), (30+3*rev) FROM revision")]]
}}}

{{{
#!html
<img src="http://chart.apis.google.com/chart?chxt=y&chd=t:1.0,2.0,3.0,4.0|12.0,14.0,16.0,18.0|33.0,36.0,39.0,42.0&chco=ff0000,00ff00,0000ff&chs=300x150&cht=lc&chdl=Animals|Vegetables|Minerals" >
}}}

=== Add a fill

{{{
[[GChart( chxt="x,y", chf="c,lg,45,ffffff,0,76A4FB,0.75|bg,s,EFEFEF",
          chco="ff0000", chs="300x150", type="lc", 
          chxl="0:|1|2|3|4|5|1:||50|100", chls="4.0,3.0,0.0",
          query="SELECT id FROM ticket")]]
}}}

Equivalent to multi-line macro:
{{{
{{{
#!GChart
  type  = "lc",           # chart type equivalent to 'cht'
  chxt  = "x,y",
  chf   = "c,lg,45,ffffff,0,76A4FB,0.75|bg,s,EFEFEF",
  chco  = "ff0000",       # chart color: blue
  chs   = "300x150",      # chart image size
  chxl  = "0:|1|2|3|4|5|1:||50|100",
  chls  = "4.0,3.0,0.0",
  query = "SELECT id \
           FROM ticket"
}}}
}}}

{{{
#!html
<img src="http://chart.apis.google.com/chart?chxt=x,y&chd=t:30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0&chf=c,lg,45,ffffff,0,76A4FB,0.75|bg,s,EFEFEF&chco=ff0000&chs=300x150&cht=lc&chxl=0:|1|2|3|4|5|1:||50|100&chls=4.0,3.0,0.0" >
</p>
}}}

See README.txt for more information.

'''Note''': This plugin currently uses an eval() statement to turn parameters in Python dict syntax into an actual dictionary. This means you can pass tuples and lists to the engine. However, it is also risky, since you are allowing the author of the wiki page to execute arbitrary Python code. Until this has been replaced by a more limited parser that only accepts primitive types, do not use this plugin in an environment where you don't trust your users.

Patches to fix this are welcome!

For example, using JSON: install simplejson, then in Python:
{{{
>>> args = '["hurray",{"for":"json"}]'
>>> import simplejson
>>> simplejson.loads(args)
["hurray", {"for":"json"}]
}}}

== Bugs/Feature Requests

Existing bugs and feature requests for GoogleChartPlugin are 
[report:9?COMPONENT=GoogleChartPlugin here].

If you have any issues, create a 
[/newticket?component=GoogleChartPlugin new ticket].

[[TicketQuery(component=GoogleChartPlugin&group=type,format=progress)]]

== Download

Download the zipped source from [export:googlechartplugin here].

== Source

You can check out GoogleChartPlugin from [/svn/googlechartplugin here] using Subversion, or [source:googlechartplugin browse the source] with Trac.

== Installation

General instructions on installing Trac plugins can be found on the [TracPlugins#InstallingaTracplugin TracPlugins] page.

== Recent Changes

[[ChangeLog(googlechartplugin, 3)]]

== Author/Contributors

'''Author:''' [wiki:optilude] [[BR]]
'''Maintainer:''' [[Maintainer]] [[BR]]
'''Contributors:'''