jquery - Jquery Bargraph没有正确加载

Question

我正在使用条形图在仪表板上加载我的 mysql 数据。问题是当我添加 qc_point =100 时，它直接从 100 开始并且不显示同一用户的图表。它应该从 0 开始。

仪表板 ：-

数据库：-

数据.php：-

//query to get data from the table
$query = sprintf("SELECT qc_user, sum(qc_point) as qc_point FROM qc group by qc_user ORDER BY qc_user");


//execute query
$result = $mysqli->query($query);

//loop through the returned data
$data = array();
foreach ($result as $row) {
    $data[] = $row;
}

app.js :-

method: "GET",
        success: function(data) {
            console.log(data);
            var qc_user = [];
            var qc_point = [];

            for(var i in data) {
                qc_user.push(data[i].qc_user);
                qc_point.push(data[i].qc_point);
            }



            var chartdata = {
                labels: qc_user,
                datasets : [
                    {
                        label: 'Technical',
                        backgroundColor: 'rgba(200, 200, 200, 0.75)',
                        borderColor: 'rgba(200, 200, 200, 0.75)',
                        hoverBackgroundColor: 'rgba(200, 200, 200, 1)',
                        hoverBorderColor: 'rgba(200, 200, 200, 1)',
                        data: qc_point
                    }
                ]
            };

            var ctx = $("#mycanvas");

            var barGraph = new Chart(ctx, {
                type: 'bar',
                data: chartdata
            });
        },
        error: function(data) {
            console.log(data);
        }
    });
});

标签： jquerychart.js

Answer 1

添加到您的 chartjs 选项：

options: {
        scales: {
            yAxes: [{
                ticks: {
                    beginAtZero:true
                }
            }]
        }
    }