I would like to create a google line chart to show monthly sales over two years.
Not worrying about the quotes and brackets, is it possible for executeSql to return a summary like the one below.
['Month', '2016', '2015'],
['JAN', 1000, 400],
['FEB', 1170, 460],
['MAR', 660, 1120]
Single column is straight ahead
mth, sum (amount)
yr = 2015
Its just the 'double' summary that is the question.