I'm not sure I understand the problem. Please see inline: On Mon, Dec 19, 2011 at 12:10 PM, TapioK <[email protected]> wrote:
> Hi all, > > I am trying to get fusiontables, maps and charts to work together. > > Is it possible to select "active" column from the same drop-down menu > maps is using? > Which drop-down menu are we talking about here? Is that part of the fusion tables UI? > > Here is the example: > http://dl.dropbox.com/u/26123216/fusionesimerkkisimppeli5.html > > What I'm trying to do, is to get chart showing countries on x-axis (as > it is now) and on y-axis the same column that map is showing. Is this > possible? > I see that your query is fetching two columns - isn't the first column containing countries and the second containing some metric on that country? I see that the response is: {"cols":[{"id":"col2","label":"maa","type":"string"},{"id":"col3","label":"mediaaniik","type":"number"}],"rows":[{"c":[{"v":"Jemen"},{"v":18.1}]},{"c":[{"v":"Syyria"},{"v":21.9}]},{"c":[{"v":"Jordania"},{"v":22.1}]},{"c":[{"v":"Oman"},{"v":24.1}]},{"c":[{"v":"Egypti"},{"v":24.3}]},{"c":[{"v":"Libya"},{"v":24.5}]},{"c":[{"v":"Saudi-Arabia"},{"v":25.3}]},{"c":[{"v":"Marokko"},{"v":26.9}]},{"c":[{"v":"Algeria"},{"v":27.6}]},{"c":[{"v":"Libanon"},{"v":29.8}]},{"c":[{"v":"Tunisia"},{"v":30}]},{"c":[{"v":"Qatar"},{"v":30.8}]},{"c":[{"v":"Bahrain"},{"v":30.9}]},{"c":[{"v":"Eesti"},{"v":40.5}]},{"c":[{"v":"Kreikka"},{"v":42.5}]},{"c":[{"v":"Suomi"},{"v":42.5}]}],"p":{"totalrows":16}} (BTW: There is no need to refresh the chart every 10s if the data is static) So, I'm not sure what the issue is, do you expect a different matrix (you are fetching "mediaaniik" maybe you want to fetch a different column? > Now the query is just: "query": "SELECT maa, mediaaniika FROM 2332949 > WHERE maa>'0' ORDER BY 'mediaaniika'" > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- Yinnon Haviv. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
