Geo Chart with a 3 column data table

  • Resolved vaishakhi

    (@vaishakhi)


    4 years, 10 months ago

    Hello Meitar,
    firstly thank you for such an elegant plugin. I was able to create a google Geo chart with relative ease. It gook a couple of hours to get the JSON right and currently have a workable chart with the following shortcode
    [gdoc key=”https://docs.google.com/spreadsheets/d/1kE2FEhH6tyXWeRmainroG7WskZdKnyzp756i9SfGm4s/edit” chart=”Geo” title=”Countries Visited” chart_legend=”none” ?expire_in=300? chart_color_axis='{“colors”: %5B? “orange”, “green” %5D }’? ]

    My question is regarding the ability to use another column for the tooltip. Google visualization documentation does allow a third column defined with a specific role for tooltip. So its technically possible. It does look like when I add another column on the shared sheets the plugin errors out saying that it is looking only for 2 columns.
    If you would consider adding this functionality (or point me to the right way to to it) it would make this plugin a little more amazing than it already is!
    Thanks again

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    It does look like when I add another column on the shared sheets the plugin errors out saying that it is looking only for 2 columns.

    If you would consider adding this functionality (or point me to the right way to to it) it would make this plugin a little more amazing than it already is!

    This sort of error indicates a mismatch between the data format expected by your chosen chart and the retrieved data in your spreadsheet. It’s a user error, not a missing feature. This is addressed by the FAQ question under the headline, “Nothing appears where my chart should be.”

    Thread Starter vaishakhi

    (@vaishakhi)

    What I’ve noticed is that if I have two columns both string, the first is used to identify the region, the second is used to put on the tooltip. But in this case all the identified regions are the same color.
    If I change the second column to a numeric value then I can utilize the different region colors but the tooltip now has the numeric value listed (which in my case is arbitrary).
    My wish is to be able to customize the the map with a custom tooltip (a feature google does support)
    If scripting directly with the maps API it would require specifying the third column as a tooltip.
    It’s not a bug but more of a feature request that I hope you would consider in the future.

    Plugin Author Meitar

    (@meitar)

    My wish is to be able to customize the the map with a custom tooltip (a feature google does support)

    Then you should be asking your question on the Google Product support forums, since this plugin merely passes your values to the Google Visualization API backend, as is mentioned numerous times throughout this forum and this plugin’s readme. Put another way, if you can do it with a Google Chart using any of the documented Google Chart attributes listed in this plugin’s readme (spoiler alert: all of the Google Chart configuration options are passed by this plugin), then you can do it with this plugin by using the same exact configuration.

    Put yet another way: your “feature request” has been implemented years ago. Now you just need to actually use it, and if the error you’re seeing is the one you reported, then the error is in your use of the Google Chart API, for which you can seek support at the Google Product support forums.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Geo Chart with a 3 column data table’ is closed to new replies.

Tags