Home forums Using CanvasJS Multiseries column charts Reply To: Multiseries column charts

#15830

ElToredo
Member

(My post must have vanished)

Hello,

I must say that I’m kind of lost in the code. I have like 2000 values and for each one of them, a date associated and I would like to put them into my graph, in the following way for which I put the points myself :

data: [
      {        
        type: "line",
        color: "rgb(85, 118, 180)",
        showInLegend: true,
        markerSize: 0,
        legendMarkerType: "line",
        legendText: "FONDS",
        lineThickness: 2,
        dataPoints: [
        { x: new Date(2006, 00, 05), y: 0.00 },
        { x: new Date(2006, 00, 07), y: 0.08 },
        { x: new Date(2006, 00, 08), y: 0.07 },
        { x: new Date(2006, 00, 09), y: 0.09 },
        { x: new Date(2006, 00, 11), y: 0.12 },
        { x: new Date(2006, 00, 13), y: 0.16 },
        { x: new Date(2006, 00, 14), y: 0.11 },
        { x: new Date(2006, 00, 15), y: 0.12 },
        { x: new Date(2006, 00, 17), y: 0.14 },
        { x: new Date(2006, 00, 19), y: 0.22 },
        { x: new Date(2006, 00, 20), y: 0.24 },
        { x: new Date(2006, 00, 21), y: 0.26 },
        { x: new Date(2006, 00, 22), y: -0.05 },
        { x: new Date(2006, 00, 24), y: 0.08 },
        { x: new Date(2006, 00, 25), y: 0.15 },
        { x: new Date(2006, 00, 26), y: 0.36 },
        { x: new Date(2006, 00, 28), y: 0.34 },
        { x: new Date(2006, 00, 30), y: 0.33 },
        { x: new Date(2006, 01, 01), y: 0.33 },
        { x: new Date(2006, 01, 02), y: 0.45 },
        { x: new Date(2006, 01, 03), y: 0.25 },
        { x: new Date(2006, 01, 05), y: 0.60 },
        { x: new Date(2006, 01, 06), y: 0.62 },
        { x: new Date(2006, 01, 07), y: 0.67 },
        { x: new Date(2006, 01, 09), y: 0.50 },
        { x: new Date(2006, 01, 11), y: 0.85 },
        { x: new Date(2006, 01, 12), y: 1.20 },
        { x: new Date(2006, 01, 13), y: 0.78 },
        { x: new Date(2006, 01, 14), y: 0.92 },
        { x: new Date(2006, 01, 16), y: 0.95 },
        { x: new Date(2006, 01, 17), y: 1.36 },
        { x: new Date(2006, 01, 18), y: 1.32 },
        { x: new Date(2006, 01, 20), y: 1.36 },
        { x: new Date(2006, 01, 22), y: 1.23 },
        { x: new Date(2006, 01, 23), y: 1.52 },
        { x: new Date(2006, 01, 24), y: 1.60 }
        ]
      }
      ]

I would like to understand how to use this sample project to be able to extract those points in my database, which are written in this way : YYYY-MM-DD for the dates (like 2017-08-16) and XXX.XX for the values (like 952.25).

Could you help me please? I’m using SQL Server and Microsoft SQL Server Management to handle my database.

Thanks!
Tanguy.