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/-/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.
