Sign in to follow this  
wakaster

using Google Doc spreadsheets

Recommended Posts

Hi,

 

 

 

First of all: congrat to your work. Quite impresive.

 

 

 

We are actually looking at ways to present our data on the wbe, using for the mment Google Doc spreadsheets.

 

 

 

The idea is to have people feeding the data in the spreadsheets but the result (using fusion Chart is an example) displaye din a website.

 

 

 

Our current are as follow:

 

 

 

- With google apps and visualisation, it is possible to querry the tabel in order to group and sum some areas for the graphic/chart display.

 

 

 

is it possibel to do so wihtin Fusin Chart (in the form of the gadget it is not seems possible.

 

 

 

 

 

- The data range request that we enter the address of cells. Actually, if we want to automate the process, we woud like the tol to get the full column... ??

 

 

 

Current querry sample (Group and sum)

 

function drawVisualization() {

 

var query = new google.visualization.Query(

 

'http://spreadsheets.google.com/ccc?key=pIrV50N9kwm5b8acslyW2aA');

 

 

 

// Apply query language.

 

 

 

 

 

query.setQuery('select D,sum(E),sum(F) group by D');

 

 

 

query.send(handleQueryResponse);

 

}

 

function handleQueryResponse(response) {

 

if (response.isError()) {

 

alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());

 

return;

 

}

Share this post


Link to post
Share on other sites

maybee I am not that clear indeed.

 

 

 

We are using Google Docs Spreadsheet.

 

We have a table in it and we apply the FusionChart ' Gadget' on it.

 

 

 

However we encounter the following issues:

 

 

 

- Range of the data : we need to provide the cells array (like A1:E80) but actually if we are adding new lines / data, the array to cover should be changed each time we are adding line.

 

 

 

Isn't it possible to get the column (A:E)

 

 

 

- Grouping/Sum of data.

 

If we present a chart (or pyramid or other) on the data, isn't it possible to give a querry in order to group data and sum the numericals about these data.

 

 

 

Sample:

 

if you have a 4 column table:

 

Type ! date ! Price | Weight

 

 

 

And you try to chart them by 'Types' , you will need to :

 

- group all the similar types on the chart (so they do not show duplicate)

 

- sum all the value associated (say the Price -in %) to a specific type

 

 

 

hope it help to answer the question

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this