Home › Forums › Chart Support › Show a last 12 months chart with php mysql

Show a last 12 months chart with php mysql

Viewing 3 posts - 1 through 3 (of 3 total)

Tagged: ,

  • May 8, 2021 at 2:31 am #34261

    aMoN75

    Hello,

    I need to render a chart with php/mysql from this table :

    TABLE MYSQL

    We need to show a X axis (LAST 12 months) and Y axis (number of cliks with the same id_aff) `

    If someone can help me, thanx a lot.
    AmoN

    May 8, 2021 at 2:38 am #34262

    aMoN75

    My code : code

    May 10, 2021 at 6:48 pm #34282

    Manoj Mohan

    AmoN,

    You are passing values instead of y within $dataPoints. Replacing $dataPoints[0] = array("value" => $row["values"], "label"=> $row["date(timestamp)"]) with $dataPoints[0] = array("y" => $row["values"], "label"=> $row["date(timestamp)"]) should work fine in this case.

    —-
    Manoj Mohan
    Team CanvasJS

Viewing 3 posts - 1 through 3 (of 3 total)

Tagged: ,

You must be logged in to reply to this topic.