Generating a pie chart on-line from aggregate published to google sheets

Hi,
Has anyone done this? I want to publish a graphic made in the google sheet
that aggregate is publishing to. Problem is, each time a new record is sent
to the google sheet, it throws off my calculation by one more line and the
graphic never gets updated because it never sees the new line.

More specifically. I have a 3 item multi-response question with values
published to say column M in my ggsheet. So I see values in column M like 0
or 0 2 or 0 1 2, etc. I created a second sheet (tab) to create a count for
response 1, response 2, and response 3 (used a formula to pick out if there
was a 0 or 1 or 2) which worked fine on the 10 lines of data already there
and I had a nice pie chart with a url to post it anywhere. But my
calculations are based on lines from the first sheet that WILL exist when
they are pushed by aggregate. Unfortunately, when a new line is created in
that sheet, and say M15 cell now has 1 2, my other sheet that was waiting
for M15 to make a copy of it (A15) now is looking for M16 but that hasn't
been created yet. Next submission, cell A16 will try to make a copy of M18
which of course doesn't exist yet and the spread gets bigger each time.

Curtis

This is a spreadsheet that you have open and you want it to update?

Can you use the onEdit event
https://developers.google.com/apps-script/guides/triggers/

in a script?

ยทยทยท On Thu, Feb 5, 2015 at 9:43 AM, Curtis Broderick <curtisbroderick1@gmail.com wrote:

Hi,
Has anyone done this? I want to publish a graphic made in the google sheet
that aggregate is publishing to. Problem is, each time a new record is sent
to the google sheet, it throws off my calculation by one more line and the
graphic never gets updated because it never sees the new line.

More specifically. I have a 3 item multi-response question with values
published to say column M in my ggsheet. So I see values in column M like 0
or 0 2 or 0 1 2, etc. I created a second sheet (tab) to create a count for
response 1, response 2, and response 3 (used a formula to pick out if there
was a 0 or 1 or 2) which worked fine on the 10 lines of data already there
and I had a nice pie chart with a url to post it anywhere. But my
calculations are based on lines from the first sheet that WILL exist when
they are pushed by aggregate. Unfortunately, when a new line is created in
that sheet, and say M15 cell now has 1 2, my other sheet that was waiting
for M15 to make a copy of it (A15) now is looking for M16 but that hasn't
been created yet. Next submission, cell A16 will try to make a copy of M18
which of course doesn't exist yet and the spread gets bigger each time.

Curtis

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I also face the same problem in a graph of google sheets. I learn the process to make a graph in google sheets from the one tutorial. I got my half solution in this tutorial but It was not exactly what I want. If you want to learn that then you can click here. But the suggestion link that I got in this thread is almost the same but the process on the extra level. This what I want to learn. So thanks for the suggestion. Thank you very much. :grinning: