hi asgallant, thanks for the suggestion; pointing me directly to the bits
of relevant docs was very useful indeed!
although the query language itself is rather limited, using the dataview
stuff allowed me to solve the problem. for those reading the thread,
basically creating a view reduces the
The query language is insufficiently sophisticated to do what you want.
You will have to filter out the values you want using the DataTable
methodshttps://developers.google.com/chart/interactive/docs/reference#DataTable,
and perhaps the group function