轴#0的数据列不能为字符串类型Java语言错误

当我尝试使用Google图表库创建自己的图表时,它给了我Data column(s) for axis #0 cannot be of type string error.

我正在使用Ajax库的http请求接收数据。我创建了类似的数组;


    0: (2) ["Time","Value"]
    1: (2) ["Tue Nov 05 2019 00:00:00 GMT+0300 (GMT+03:00)",49.4638863]
    2: (2) ["Tue Nov 05 2019 01:00:00 GMT+0300 (GMT+03:00)",73.19763]
    3: (2) ["Tue Nov 05 2019 02:00:00 GMT+0300 (GMT+03:00)",91.66373]

当我检查示例和文档时,我的数组类型看起来正确。


    google.charts.load('current',{'packages':['corechart']});
    google.charts.setOnLoadCallback(drawChart);

    var endpoint = "http://127.0.0.1:8000/api/api"
    var chartData = [["Time","Value"]];
    console.log(typeof chartData)
    $.ajax({
    method: "GET",url: endpoint,success: function(data){
    var valueData = data;
    for(i = 0; i< data.length; i++){
        //console.log("Time Data: ",data[i].time)
        chartData.push([String(new Date(data[i].time)),Number(data[i].value)]);
        }
        //console.log("Chart Data: ",chartData);
    },error: function(error_data){
        console.log("error")
        console.log(error_data)
        }
    });

    function drawChart() {
        console.log(chartData)
    var data = google.visualization.arrayToDataTable([
        chartData
    ]);

    var options = {
        title: 'Tag Value',curveType: 'function',legend: { position: 'bottom' }
    };

    var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

    chart.draw(data,options);
    }

chartData是;


    0: (2) ["Time",91.66373]
    4: (2) ["Tue Nov 05 2019 03:00:00 GMT+0300 (GMT+03:00)",98.4258347]

要如何将我的数组推送到Google图表而不出现此错误,该怎么办。

xuzhihua131792 回答:轴#0的数据列不能为字符串类型Java语言错误

需要在此处删除多余的括号

var data = google.visualization.arrayToDataTable(chartData);

arrayToDataTable接受一个数组数组,您将在此处创建...

var chartData = [["Time","Value"]];

添加到此处...

chartData.push([String(new Date(data[i].time)),Number(data[i].value)]);

当前,您最终得到...

[[["Time","Value"],[...],[...]]]

注意:给定数据的格式,无需在此处强制转换类型...

chartData.push([new Date(data[i].time),data[i].value]);
本文链接:https://www.f2er.com/3146567.html

大家都在问