Google charts in PPSM

Don’t tell MSFT I said this but this is really quite cool: 


http://code.google.com/apis/chart/


The Google charts API allows you to create charts as a web page by simply setting the querystring:


http://chart.apis.google.com/chart?chs=400×200&chd=t:50,10,20,20&cht=p3&chl=Bully|Jezza|Sach|Tim&chtt=Who+ate+all+the+pies


If you use it in conjunction with a simple web page that is picking up the parameters from a PPSM filter (like Nick B has created here) you’ve got some instant functionality – e.g. display the country/state you’ve filtered on.  Here, I’ve taken Nick’s example and built the response.redirect statement to include the country code from a tabular data source based on the parameter selected:


image 


Taking it a step further you could create a custom report type using the SDK for PPSM that connects to one of the built in data sources and prepares a querystring.


The main drawback is of course that you need an Internet connection to display the charts.  Another drawback is that there is a limit to length of a querystring so thousands of data points is not possible (nor should it be allowed in charts!!) but other than that this a definitely a short-term solution to some of the shortcomings of the built-in PPSM V1 chart.


Sample Code and BSWX

Leave a Reply

Your email address will not be published. Required fields are marked *