Advanced Google Query to pivot values

gistfile1.txt

say you have a spreadsheet formatted thusly (for instance a survey form):

timestamp, user, question
'2013-01-01', person1, Y
'2013-01-01', person2, Y
'2013-01-01', person3, N

and you want to get a count, by day, of the responses like:

Date, Y, N
'2013-01-01', 2, 1

The below function will do that for you. Notice the use of the toDate function to allow grouping by day. Also notice the pivot C which pivots the question column.

=QUERY('Form Responses'!A:D;"select toDate(A),  count(D)  where B != '' group by toDate(A) pivot C label  toDate(A) 'Day'")