Tableau的Javascript

Question

我有一本表格工作簿

• 2张
  • 条形图(称为条形图)
  • 饼形图(称为饼图)

​

• 2个仪表板
  • 全屏条形图(称为FULLBAR的工作表)
  • 饼图全屏(称为FULLPIE的工作表)

​

现在，我试图将它们加载到带有按钮的HTML页面中，以便在仪表板之间切换。我遵循了教程，它引入了最初的仪表板(FULLBAR)，不过，在切换仪表板时遇到了问题。

当单击要切换的链接时，我在控制台中得到此错误。

Error: Sheet is not found in Workbook

这是我的代码(服务器显然是XXXX‘’ed的)

<!doctype html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <title>Proof of Concept</title>
        <meta name="description" content="Proof of Concept">
        <meta name="author" content="thisDude">

        <script type="text/javascript" src="http://xxx.xxx.xxx.xxx:xxxx/javascripts/api/tableau-2.0.0.js"></script>

        <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.2/jquery.min.js"></script> 
        <script type="text/javascript" src="js/bootstrap.js"></script>
        <script type="text/javascript" src="js/app.js"></script>
        <link rel="stylesheet" type="text/css" href="css/bootstrap.css">
        <link rel="stylesheet" type="text/css" href="css/style.css">

</head>
<body>
    <div class='container'>
        <div class='row'>
            <div class='span3 col-xs-6'><img style="height:39px; width:100px;" src="logo.jpg" ></div>
            <h2 class='col-xs-6 span7 pagination-centered'>Proof of Concept</h2>
        </div>
        <div class='row'>
            <h3 class='offset3 span7 pagination-centered' id='sheetName'></h3>
        </div>
        <div class='row'>

            <!-- All of our work will happen here -->
            <!-- Viz located at http://xxx.xxx.xxx.xxx:xxxx/views/TEST_VIS2/FULLBAR -->
            <ul id = 'menu' class='nav nav-list offset1 span2'>
                <!-- This is the menu where we will add all of our buttons. -->
                <li class='nav-header'>Switching Views</li>
                <li><a onClick="switchView('FULLBAR')">Bar Chart</a></li>
                <li><a onClick="switchView('FULLPIE')">Pie Chart</a></li>                
            </ul>
            <div id='tableauViz'></div>
            <script>
            </script>


            <!-- This is the end of the section where we will do our work. -->
        </div>
    </div>
</body>
</html>

我的app.js代码：

window.onload=function() {
    var vizDiv = document.getElementById('viz');
    var vizURL = "http://xxx.xxx.xxx.xxx:xxxx/views/TEST_VIS2/FULLBAR_1";
    var options = {
        width: '100%',
        height: '500px',
        hideToolbar: true,
        hideTabs: true
    };

    viz = new tableauSoftware.Viz (vizDiv, vizURL, options);
};

function switchView(sheetName) {
    workbook = viz.getWorkbook();
    workbook.activateSheetAsync(sheetName);
    console.log(sheetName);
    console.log(workbook + " workbook var");
    console.log(viz.getWorkbook() + " viz.getWorkbook var");
}

Answer 1

找到了答案--

我最初是用“Sheets as Tabs”选项发布到服务器的。我的javascript也使用了hideTabs: true。

这样做会导致JS不知道工作表的名称。

通过在发布“Sheets as Tabs”期间选择该选项，API能够正确地切换可视化。js选项"hideTabs: true“仍然隐藏着可视选项卡。

Answer 2

我的公开账户里有三张床单。我创建了两个按钮，并将其描述为java脚本文件，如下所示。

function switchView(sheetName) { var workbook = viz.getWorkbook(); workbook.activateSheetAsync(sheetName)；}单击按钮后不执行任何操作。