Hey! INTRO: I am messing around with the Visualization API. I've created
dynamic charts, tables and graphics in the past with Excel no problem. I
would like to transition to using Google for more flexibility and ease of
sharing. I made some dynamic tables (using pivots, vlookups, and indexing)
that correspond to charts and graphs in a spreadsheet. Now I would like to
get familiar with display this data in HTML/JS formats for a simple
dashboard so everyone does not have to share the spreadsheets to view the
data.
PROBLEM: I have successfully linked my spreadsheet to a test JSFiddle to
collect the data I want. Now I would like to have it update, similar to a
vlookup, the data in I2,J2,K2 based on the string in H2. The list values
are in A2:A24. So I would like the RangeFilter to change the value in the
spreadsheet based on the value selected from the list, thereby updating the
vlookup and changing the data. Is this the correct path of thought or is
this simply a read-only application? Or a simpler way of accomplishing this
perhaps? Thoughts appreciated.
var queryString = encodeURIComponent('SELECT H,I,J,K');
var chartRangeFilter = new google.visualization.ControlWrapper({
'controlType': 'CategoryFilter',
'containerId': 'control_div',
'options': {
'filterColumnIndex': 0
}
MY THOUGHTS: I thought maybe to call the pivot table, not display it then
use that data to draw the chart and use the first column of the pivot as
the list? Not sure how to accomplish that though.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/4fef1818-6d39-43f4-8e10-b7f63ff7398a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
