Yes you can use a google spreadsheet. I haven't done it but here's the info on it: https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source
On Tue, Aug 14, 2012 at 11:27 AM, Tracy Ridge <[email protected]> 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<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/-/Hw9Lg9XZDGAJ. > > 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. > -- 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.
