Hi there, I found this API by trying to find a way to replicate the functionality of a "COUNTIFS" function in a spreadsheet. After a little bit of working, I was able to do what I needed by using a fairly simple query -- but I found the function spanned multiple lines by default -- I need to use the 'labels' clause, setting it to an empty quote to get on one line. So that's fine -- it works, but my problem is in the need to duplicate a complicated aggregate select expression in the 'labels' clause... is there no way to alias a column and reference that ID in the labels clause?
i.e., =query( $A1: $C25, "select count(A) - count(B) where C=TRUE label count(A) - count(B) ''" here I need to type "count(A) - count(B)" twice -- once in the select clause and another in the labels clause I want to make this "select count(A) - count(B) as TOTAL where C=TRUE label TOTAL '' " Is there a better way to do this? Thanks. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. 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.
