代码之家  ›  专栏  ›  技术社区  ›  shrey Pav

谷歌可视化多条形图

  •  1
  • shrey Pav  · 技术社区  · 6 年前

    我正在处理这个需求,其中我在 barchart Type mismatch. Value 5 does not match type string in column index 0 我只添加了一些表代码和图表代码片段。 有什么帮助吗?提前谢谢。

    表代码:

         success: function (data) {
          if (data.length > 0) {
    
          var tr;
          var monthNames = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];
    
          var cbs = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];
          var cbns = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];
          var cbn = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];
        for (var i = 0; i < data.length; i++) {
    
          var value = data[i].MonthCol;
    
        //Switch case to get the values for each column monthwise......
           }
    
    
           for(var i =0;i<12;i++){
              if (qualityvalue[i]) {
               tr = $('<tr/>');
               tr.append("<td>" + monthNames[i] + "</td>");
               tr.append("<td>" + cbs[i] + "</td>");
               tr.append("<td>" + cbns[i] + "</td>");
               tr.append("<td>" + cbn[i] + "</td>");
               $('#GraphTable').append(tr);
                                }
    
    
                            }
    
      $('#GraphTable').append('<tr style="font-weight: bold; background-color: white"></tr>');
    ...//code 
    
                    var tdata = new google.visualization.DataTable();
                    tdata.addColumn('string', 'Month');
                    tdata.addColumn('number', 'Name1');
                    tdata.addColumn('number', 'Name2');
                    tdata.addColumn('number', 'Name3');
    
                    for (var i = 0; i < 12; i++) {
                        if (qualityvalue[i]) {
                            tdata.addRow([monthNames[i], parseFloat(cbs[i]), parseFloat(cbns[i]), parseFloat(cbn[i])]);
                        }
                    }
    
                    var options = {
                      //code
                        title: 'Quality Chart ',
                        vAxis: {
                            title: ' ', titleTextStyle: { color: 'black', bold: true }, 'maxValue': 1, format: '#', gridlines: { count: 10, color: 'transparent' },
    
                        },
                        hAxis: { title: 'Month', titleTextStyle: { color: 'black', bold: true }, gridlines: { count: 12 }, maxAlternation: 1, showTextEvery: 1, minTextSpacing: 8 },
                        seriesType: 'bars',
    
                    };
                    var chart = new google.visualization.ColumnChart(document.getElementById('cumulative_div'));
                    chart.draw(tdata, options);
    

    我想得到这样的图表: enter image description here

    0 回复  |  直到 6 年前