Google 饼图数据格式化：如何在切片值中显示百分比符号

var percentFormat = new google.visualization.NumberFormat({
  fractionDigits: 0, // 显示0位小数
  suffix: '%'        // 在数字后添加百分号作为后缀
});

percentFormat.format(dataTableObject, columnIndex);

function drawChartISLA(updatedDataISLA) {
    // 创建数据表
    var data = new google.visualization.DataTable();
    data.addColumn('string', 'opco_name');
    data.addColumn('number', 'count'); // 此列（索引为 1）需要格式化
    data.addColumn('number', 's1_sla_met_count');
    data.addColumn('number', 's2_sla_met_count');
    data.addColumn('number', 's3_sla_met_count');
    data.addColumn('number', 's4_sla_met_count');
    data.addRows(updatedDataISLA);

    // 创建百分比格式化器，不显示小数位
    var percentFormat = new google.visualization.NumberFormat({
        fractionDigits: 0,
        suffix: '%'
    });

    // 将格式应用到 'count' 列 (索引 1)
    percentFormat.format(data, 1);

    // 设置图表选项
    var options = {
        'title': 'Incidents SLA met percentage - ',
        'pieSliceText': 'value', // 确保显示格式化后的值
        is3D: 'true',
        'tooltip': {
            trigger: 'none' // 原始代码中此处为 'none'，如果需要显示格式化后的 tooltip，应调整
        }
    };

    // 实例化并绘制图表
    var chart = new google.visualization.PieChart(document.getElementById('IR-SLA'));
    chart.draw(data, options);

    // ... (后续事件监听及 selectHandler 函数保持不变) ...
}

function selectHandler() {
    var selection = chart.getSelection()[0];
    if (selection) {
        var sliceName = data.getValue(selection.row, 0);
        // ... (获取 sliceS1, sliceS2, sliceS3, sliceS4 等值) ...
        var sliceS1 = data.getValue(selection.row, 2);
        var sliceS2 = data.getValue(selection.row, 3);
        var sliceS3 = data.getValue(selection.row, 4);
        var sliceS4 = data.getValue(selection.row, 5);

        // 为选定切片创建数据表
        var sliceData = new google.visualization.DataTable();
        sliceData.addColumn('string', 'Severity');
        sliceData.addColumn('number', 'Incident Count'); // 此列（索引为 1）需要格式化
        sliceData.addRow(['S1', sliceS1]);
        sliceData.addRow(['S2', sliceS2]);
        sliceData.addRow(['S3', sliceS3]);
        sliceData.addRow(['S4', sliceS4]);

        // 创建百分比格式化器，不显示小数位
        var percentFormat = new google.visualization.NumberFormat({
            fractionDigits: 0,
            suffix: '%'
        });

        // 将格式应用到 'Incident Count' 列 (索引 1)
        percentFormat.format(sliceData, 1);

        // 设置选定切片的图表选项
        var sliceOptions = {
            'title': sliceName + ' SLA met percentage - ',
            pieSliceText: 'value', // 确保显示格式化后的值
            'width': 500,
            'height': 300,
            is3D: 'true',
            'tooltip': {
                'text': 'value' // 确保 tooltip 显示格式化后的值
            }
        };

        // ... (弹出窗口及居中代码保持不变) ...
        var popup = window.open('', 'myPopup', 'width=600,height=400');
        popup.document.write('<div style="margin:auto" id="slice_chart_div"></div>');
        centerPopup(popup);

        // 实例化并绘制选定切片的图表
        var sliceChart = new google.visualization.PieChart(popup.document.getElementById('slice_chart_div'));
        sliceChart.draw(sliceData, sliceOptions);
    }
}

public function updateQueryISLA()
{
    // ... (获取月份和年份等现有代码) ...

    $query = $this->db->query("SELECT o.opco_name, s1_incidents_count, s2_incidents_count, 
    s3_incidents_count, s4_incidents_count, 
    ((i.s1_sla_met_count + i.s2_sla_met_count + i.s3_sla_met_count + i.s4_sla_met_count) / 
    (s1_incidents_count + s2_incidents_count + s3_incidents_count + s4_incidents_count)) * 100 as count, 
    (i.s1_sla_met_count / s1_incidents_count) * 100 as s1, 
    (i.s2_sla_met_count / s2_incidents_count) * 100 as s2, 
    (i.s3_sla_met_count / s3_incidents_count) * 100 as s3, 
    (i.s4_sla_met_count / s4_incidents_count) * 100 as s4 
    FROM opcos_list o inner JOIN incidents_summary i ON o.id = i.opcos_list_id 
    WHERE i.month_number = $selected_month AND i.year = $selected_year");
    $rows = $query->result_array();

    $data = [];
    foreach ($rows as $row) {
        $data[] = [
            $row['opco_name'],
            (int)$row['count'], // 确保返回的是数字类型，这里强制转换为整数，如果需要小数请使用 (float)
            (int)$row['s1'],
            (int)$row['s2'],
            (int)$row['s3'],
            (int)$row['s4'],
        ];
    }
    echo json_encode($data);
}