Advanced reporting and Dashboards in Salesforce: Google Visualization with Visualforce

3:35 PM

If you haven't yet tried your hand with Google Visualization API's this is the best time to start...

Here is the link to the documentation to get started .. http://code.google.com/apis/chart/interactive/docs/reference.html

A very cool feature of this is you could generate charts just by passing parameters in the URL.

It's as simple as this, click the link https://chart.googleapis.com/chart?cht=p3&chs=450x100&chd=t:30,20,20,15,15&chl=Open|In Progress|On Hold|Pending Confirmation|Closed

As you can see, the values in PINK color are the actual segments of the chart. You may split the entire 100% as per your req, and the text in GREEN is the value for each of the segments.

How can i use this?

Well, you could just embed this into a Standard Page Layout using just a formula field. So, you get a real time snapshot right inside your detail page.

Also, you could do some complex calculations in your apex class and pass the results of the calculation to the URL as parameters and you have a nice little graph.
 
Refer to the documentation for more samples and chart types. http://code.google.com/apis/chart/interactive/docs/reference.html

0 comments

AD