Maybe you should look again at your earlier solution, to extract the data in the client side code using the 'query' option for the chart wrapper.
'query':'SELECT C,D,E,F WHERE C = "[email protected]" ', I missed the fact that you could select the row of data you want that way. But then you still need to reconstitute that in a datatable that the piechart, so like I said before: Fetch the data separately from the ChartWrapper, using a Query, as described here: https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source etc. I guess I am still missing what you are planning to do with this. If there are a finite number of columns of data (3?) and any number of rows from which you want to select just one by doing a match given some text, then the above outline of a solution sounds right to me. On Thu, Oct 23, 2014 at 11:26 AM, Rob H <[email protected]> wrote: > Thanks - Believe e if we had the luxury of a database I wouldn't be > wrangling with this :) > > We shouldn't run into size issues if we can have just four columns and a > few thousand rows. > > An option might be to look at an automation to move this to a database - > sadly that doesn't seem so easy. > > Right, onwards! > Thanks again > Rob > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart 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 http://groups.google.com/group/google-chart-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Chart 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 http://groups.google.com/group/google-chart-api. For more options, visit https://groups.google.com/d/optout.
