[CLOW]

<?php   
$data_points= array();
        
$result=  "WITH MYTAB1 AS(
        SELECT  ITEM_NBR, LOCATION ,ITEM_DATE
        FROM IEGAR.KPI_FOREMAN_HIST
        WHERE ITEM_NBR=1100
        AND LOCATION='CHIIL'
        ORDER BY 3 DESC
        FETCH FIRST 13 ROWS ONLY
        )

        SELECT H.ITEM_NBR, H.ITEM_DATE, H.LOCATION  
        , H.ITEM_VALUE, H.KPI_COMMENT, H.CALC_DEF 
        FROM IEGAR.KPI_FOREMAN_HIST H 
        INNER JOIN MYTAB1 M ON H.ITEM_NBR=M.ITEM_NBR
        AND H.LOCATION =M.LOCATION
        AND H.ITEM_DATE=M.ITEM_DATE
        order by 2
        WITH UR";
        
$result=odbc_exec($bips, $result);
       
       
    //ITEM_DATE,ITEM_VALUE...?=LOCATION
          while($row= odbc_fetch_array($result))
        {    
            if($row['ITEM_DATE'] != null){
            //echo  $row['ITEM_DATE'];
            //echo  $row['ITEM_VALUE'];
            $point = array("label" => $row['ITEM_DATE'], "y" => $row['ITEM_VALUE']);            
            array_push($data_points, $point);      
          }
            else
            {
            	$point = array("label" => "ITEM_NBR", "y" => 0);
                array_push($data_points, $point); 
            }
            
          }
            echo json_encode($data_points, JSON_NUMERIC_CHECK);
             
       
odbc_close($bips);
?>

These are my changes but I still cant get it to display

window.onload = function () {
    var dps = [];
    //$(document).ready(function () {
    $.getJSON("data.php", function (result) {
            
        chart.options.data[0].dataPoints = result;
        var chart = new CanvasJS.Chart("chartContainer", {
            //axisX: {
            //    title: "Weeks",
            //    interval: 7,
            //    intervalType: "day"
            //},
            axisY:{
                title:"Percentage",
            },
            data: [
                {
                    type: "spline",
                    dataPoints: result[
                        { "label": "2015-02-07", "y": 0.8109 },
                        { "label": "2015-02-14", "y": 0.7687 },
                        { "label": "2015-02-21", "y": 0.8223 },
                        { "label": "2015-02-28", "y": 0.7832 },
                        { "label": "2015-03-07", "y": 0.7677 },
                        { "label": "2015-03-14", "y": 0.7778 },
                        { "label": "2015-03-21", "y": 0.7745 },
                        { "label": "2015-03-28", "y": 0.7838 },
                        { "label": "2015-04-04", "y": 0.7626 },
                        { "label": "2015-04-11", "y": 0.756 },
                        { "label": "2015-04-18", "y": 0.7206 },
                        { "label": "2015-04-25", "y": 0.7922 },
                        { "label": "2015-05-02", "y": 0.73 }]
                }
            ],
            legend: {
                cursor: "pointer",
                itemclick: function (e) {
                    if (typeof (e.dataSeries.visible) === "undefined" || e.dataSeries.visible) {
                        e.dataSeries.visible = false;
                    } else {
                        e.dataSeries.visible = true;
                    }
                    chart.render();
                }
            }
        });
        chart.render();
    });
};
   

This is my read out

[{“label”:”2015-02-07″,”y”:0.8109},{“label”:”2015-02-14″,”y”:0.7687},{“label”:”2015-02-21″,”y”:0.8223},{“label”:”2015-02-28″,”y”:0.7832},{“label”:”2015-03-07″,”y”:0.7677},{“label”:”2015-03-14″,”y”:0.7778},{“label”:”2015-03-21″,”y”:0.7745},{“label”:”2015-03-28″,”y”:0.7838},{“label”:”2015-04-04″,”y”:0.7626},{“label”:”2015-04-11″,”y”:0.756},{“label”:”2015-04-18″,”y”:0.7206},{“label”:”2015-04-25″,”y”:0.7922},{“label”:”2015-05-02″,”y”:0.73}]

• This reply was modified 9 years, 7 months ago by CLOW.