Home › forums › Using CanvasJS › Average of database column
I’ve been trying this for days now with the example code, but I have no idea how this could work.. would really appreciate some help with this.
This is my database:
(want to insert a pic here but doesn’t work?)
I want to show the average of each column in a column chart, like the “Column Charts with Multiple Axes” example.
So the average of PD1 in blue and of PD2 in red, SVK1 in blue, SVK2 in red and so on. I know I can get the average with the SQL AVG() function but then I don’t know how to put them into the dataPoints array.
Can anyone help?
You must be logged in to reply to this topic.