Google maps and charts on them

[alec1982]

Hi Guys,

Are you familiar with how to add a chart on Google map on a qvw?

I have attended a demo in the past on how to do it and took a screen shot of the expression how it looks like.

Now I am trying to do the same thing but it is not working for me.

I have attached the screen shot that i took and the site to create the Google charts..

Let me know if you can help and thxs in advance!

https://developers.google.com/chart/image/docs/chart_wizard

Best

Alec

[#2]

Hi Alec

I was able to create a simple example using a text box set to "show as image" and creating the URL by joining expressions. See attached example of a bar chart.

Working code:

='http://chart.googleapis.com/chart'

  & '?chxt=y'

  & '&chbh=a'

  & '&chs=300x225'

  & '&cht=bvg'

  & '&chco=A2C180,3D7930'

  & '&chds=0,'& max(Quantity)

  & '&chd=t:' &concat(distinct Quantity,',')

  & '&chtt=Vertical+bar+chart'

The "concat" function is the one that you need to return a list of values for the data in the chart. in this example "Quantity" is a list of full numbers but you may have to do something clever with aggr() and count to return the data you need.

Regards,

Erica