给出链接按钮的图表

Table chart giving link button

本文关键字:按钮 链接      更新时间:2023-09-26
 <script type="text/javascript">
        function drawVisualization2(dataValues, chartTitle, columnNames, categoryCaption) {
            if (dataValues.length < 1)
                return;
            var data = new google.visualization.DataTable();
            data.addColumn('string', columnNames.split(',')[0]);
            data.addColumn('string', columnNames.split(',')[1]);
            data.addColumn('string', columnNames.split(',')[2]);
            data.addColumn('number', columnNames.split(',')[3]);
            data.addColumn('number', columnNames.split(',')[4]);
            data.addColumn('number', columnNames.split(',')[5]);
            data.addColumn('string', 'Email');

            for (var i = 0; i < dataValues.length; i++) {
                data.addRow([dataValues[i].Value1, dataValues[i].Value2, dataValues[i].Value3, dataValues[i].Value4, dataValues[i].Value5, dataValues[i].Value6, 'www.google.in']);
            }
            var formatter = new google.visualization.NumberFormat({ pattern: '####%' });
            formatter.format(data, 5);
            var formatter = new google.visualization.PatternFormat('<a href="{6}">{4}</a>');
            formatter.format(data, [4, 6]); 
            var view = new google.visualization.DataView(data);
            view.setColumns([0,1,2,3,4,5]);
            var categoryPicker2 = new google.visualization.ControlWrapper({
                'controlType': 'CategoryFilter',
                'containerId': 'Container1',
                'options': {
                    'filterColumnLabel': columnNames.split(',')[1],
                    'ui': {
                        'labelStacking': 'horizontal',
                        'allowTyping': false,
                        'allowMultiple': false,
                        'caption': categoryCaption,
                        'label': columnNames.split(',')[2]
                    }
                }
            });

            var table2 = new google.visualization.ChartWrapper({
                'chartType': 'Table',
                'containerId': 'TableContainer2',
                'options': {
                    'width': '895px',
                    'page': 'enable',
                    'pageSize': 5
                }
            });
            new google.visualization.Dashboard(document.getElementById('PieChartExample2')).bind([categoryPicker2], [table2]).draw(view, { allowHtml: true, showRowNumber: true });
            //visualization.draw(view, { allowHtml: true, showRowNumber: true });
        }
     </script>

我在表格图表上遇到了添加链接按钮的问题;这是我的代码。和列7需要去谷歌;首先尝试与简单的表,它工作得很好;但在控制和仪表板的情况下,它不是我尝试,但可以谁能帮助我解决。谢谢你. .

看起来基本没问题。只需将Table的allowHtml选项设置为true:

var table2 = new google.visualization.ChartWrapper({
    'chartType': 'Table',
    'containerId': 'TableContainer2',
    'options': {
        'width': '895px',
        'page': 'enable',
        'pageSize': 5,
        allowHtml: true
    }
});

同样,尝试在仪表板的draw调用中设置选项将不会做任何事情,因此删除第二个参数:

new google.visualization.Dashboard(document.getElementById('PieChartExample2')).bind([categoryPicker2], [table2]).draw(view);