Good point On Tuesday, 14 August 2012 17:23:50 UTC+1, asgallant wrote: > > Yes, you can fetch data from a Google spreadsheet, and once it's in the > client's browser, you can do anything you like with it. I don't think you > will want that, though, as the spreadsheet has to be made public in order > to query it. > > On Tuesday, August 14, 2012 11:27:54 AM UTC-4, Tracy Ridge wrote: >> >> Thanks Yolanda >> >> This is really useful. Out of interest can you take data from a google >> spreadsheet and manipulate it. I wondered whether retrieving the >> information form a google spreadsheet would be better. >> >> On Tuesday, 14 August 2012 15:26:35 UTC+1, Yolanda Davis wrote: >>> >>> Tracy, >>> >>> I think you can accomplish this all with jQuery and the Google >>> Datatable/DataView. If you are using a file to store the JSON you can save >>> it as a php file and then use jQuery ajax to read the contents of that php >>> file into a DataTable. From there you can use the group method in order to >>> do aggregate functions (sum, average, etc). Finally you can pass that into >>> your column chart. >>> >>> I hope this helps! Here is the online reference to the group method: >>> https://developers.google.com/chart/interactive/docs/reference#google_visualization_data_group >>> >>> >>> Yolanda >>> >>> On Monday, August 13, 2012 6:24:42 PM UTC-4, Tracy Ridge wrote: >>>> >>>> Hi >>>> >>>> I am just requiring a little advice on how to approach this project. >>>> I am going to place all my data in a json file. The data is a list of >>>> donations categorised by individual, company, school and miscellaneous >>>> donations. >>>> >>>> I want to make a column chart with the total(sum) of all donations from >>>> each categories and a table with the top 10 donations from the categories >>>> with the names and amount. >>>> >>>> I would prefer to do this with PHP but if easier will use jQuery and I >>>> would also like to take in consideration any security issues. Any help >>>> will be gratefully appreciated. >>>> >>>> Thanks in advance >>>> >>>> Tracy >>>> >>>>
-- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/RNlrF247LZcJ. 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.
