Home › Forums › Chart Support › Canvas will not work for me › Reply To: Canvas will not work for me
<?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}]