Question Sum function to plot chart/graph

[joenyo]

Hi friends, im currently doing a chart page to let user choose the date from the access database. Once the user choose the date, the graph will generate. This graph consists of total drink of water and cup size. I want to sum the total drink of water but i cant figure it out. Can anyone help me. below is my code

 

[jmcilhinney]

Please don't post pictures of code. Post the code as text, formatted as code. We can then copy it and use it as we require.

 

[jmcilhinney]

If I'm interpreting this correctly, you need to provide an alias for that sum in your SQL code and then use that alias as the column name when plotting your data, e.g.

SUM(drink_ml) AS total_drink_ml

and:

r("total_drink_ml")

 

[jmcilhinney]

You would also need to use GROUP BY in your SQL if you want to use an aggregate like SUM.