AnsweredAssumed Answered

google line chart with data via ExecuteSql

Question asked by rivet on Sep 30, 2016
Latest reply on Oct 4, 2016 by fmpdude

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

SELECT

mth, sum (amount)

FROM

sales

WHERE

yr = 2015

GROUP BY

mth

 

Its just the 'double' summary that is the question.

Outcomes