Hi Steve, You should probably ask this question on a forum that is more specific to Google Sheets, since the Google Charts queries are actually interpreted by the Sheets side. Try: https://groups.google.com/forum/#!forum/google-spreadsheets-api
On Wed, Dec 9, 2015 at 2:16 PM, Steven Thomasson <[email protected]> wrote: > > > On Wednesday, November 25, 2015 at 5:27:35 PM UTC-7, > [email protected] wrote: >> >> Hi, I hope someone can help. >> I have a Google sheets that has a list of donors and the dates of >> donations and their contact information. Some donors donate multiple times >> per year. I am trying to use query to generate a list of people who >> donated in the current month one year ago, but EXCLUDE any names that may >> have donated more recently. We are trying to generate a list of people to >> contact to see it they would be willing to donate again but don't want to >> bother them if they have already donated more recently than one year. >> >> Any ideas on how to do this would be appreciated. >> Steve >> > > This is what I have so far: > =query('Donors & Sponsors'!A4:H, "select A, sum(F) where A <> '' and date > '" & text(B1, "yyyy-mm-dd") & "' <= toDate(C) and toDate(C) <= date '" & > text(C1, "yyyy-mm-dd") & "' group by A label A 'Name', sum(F) 'Total > contribution' ",1) > > This gives me a list of donors that gave a year ago but does not exclude > any people have donated more recently. I cannot figure out how to do > that. Someone please help. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/e749fc79-9c3a-46a4-ae2a-5b53e40d9b77%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/e749fc79-9c3a-46a4-ae2a-5b53e40d9b77%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJMhhOTM45jCBPnpztjBXc1K9RhwonWNU23avzbDf4L4tg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
