我有一个SQL查询,可将数据输出到数组中,并在Google图表中使用它。当数字字段的格式设置为原始数字(例如374000000)时,图表和代码中的格式将按预期工作。工具提示会正确显示货币和逗号(例如$ 374,000,000)。但是,由于我将表格包括在图表下方,因此很难使用。因此,当我在SQL中正确格式化数字并将其显示在表格中(例如374,000)时,Google图表工具提示将显示$ 4。我不知道发生了什么事。到目前为止,这是我尝试过的:
<script type="text/javascript">
google.charts.load('current',{packages: ['corechart'],callback: drawChart});
function drawChart() {
var tableRows = [];
var results = document.getElementById('chart');
Array.prototype.forEach.call(results.rows,function(row) {
var tableColumns = [];
Array.prototype.forEach.call(row.cells,function(cell) {
var cellText = cell.textContent || cell.innerText;
switch (cell.cellIndex) {
case 0:
tableColumns.push(cellText.trim());
break;
default:
switch (row.rowIndex) {
case 0:
tableColumns.push(cellText.trim());
break;
default:
tableColumns.push(parseFloat(cellText));
}
}
});
tableRows.push(tableColumns);
});
var data = google.visualization.arrayToDataTable(tableRows);
var formatter = new google.visualization.NumberFormat(
{negativeColor: 'red',negativeParens: true,pattern: '$###,###'});
formatter.format(data,1);
var options = {
slices: { 0: {offset: 0.2},1: {offset: 0.2},2: {offset: 0.0},3: {offset: 0.1},4: {offset: 0.0},},title: 'nice chart',titleTextStyle: {color: 'black',fontSize: 28},bar: {groupWidth: '70%'},chartArea: { backgroundColor: { fill: '#F0F8FC',opacity: 100 }},fontSize:12,legend: { position: 'right',textStyle: { color: 'black',fontSize: 12}},tooltip: {isHtml: true},is3D: true,};
var chart = new google.visualization.PieChart(document.getElementById('chart_dev'));
chart.draw(data,options);
}
</script>