Fifty-Two- Tableau Extension “Load-Tableau-Summary-Data“

最新推荐文章于 2022-03-15 10:33:15 发布

BerryBC

最新推荐文章于 2022-03-15 10:33:15 发布

阅读量198

点赞数

分类专栏：三世书记录

本文链接：https://blog.csdn.net/BerryBC/article/details/108654365

版权

三世书记录专栏收录该内容

66 篇文章 4 订阅

订阅专栏

Load Tableau Summary Data

Introduction

When using tableau extension, how to convert tableau summary data to 2D array requires complex conversion.

This package can easily merge multiple worksheets with the same dimension into corresponding two-dimensional arrays.

Use

In the extension:

HTML, first load the tabelau extension plug-in, and then load this plug-in.

...
	<!-- First load the tabelau extension plug-in, and then load this plug-in -->
    <script src="./thirdpt/tableau.extensions.1.4.0.min.js"></script>
	<script src="./secondpt/loadsummarydata.js?t=202009151521"></script>
...

Load the configuration according to the settings of tableau worksheet. If the configuration of the worksheet is as follows:

JS code is as follows:

var objData = {};
objData.tLoadData = new tLoadSD();
var jsonFormated = [
    { wsName: "Cat_Sales", valueName: "Measure Values", rowTitle: ["City","State/Province"] , colTitle: ["Sub-Category","Category"] },
    { wsName: "Sales_Gth", valueName: "Measure Values", rowTitle: ["City","State/Province"] , colTitle: ["YEAR(Ship Date)"] }
  ];

$(function() {
    tableau.extensions.initializeAsync().then(function() {
        objData.tLoadData.loadCfg([], jsonFormated);.
        objData.tLoadData.LoadCol(function() {
            objData.tLoadData.ConvToTable(function() {
                console.log(objData.tLoadData.source);
            });
        });
    };
};

在这里插入图片描述

How to use it

loadCfg(jsonColTitle, arrWS)

JSON jsonColTitle column title and corresponding column number
Array < JSON > arraws worksheet

Follow up operations can only be carried out after configuration. The ‘arrcoltitle’ can not be configured first. If not, the header of each worksheet can be obtained automatically through the function

-Do not configure column header information for the time being

var jsonFormated = [
    { wsName: "Cat_Sales", valueName: "Measure Values", rowTitle: ["City","State/Province"] , colTitle: ["Sub-Category","Category"] },
    { wsName: "Sales_Gth", valueName: "Measure Values", rowTitle: ["City","State/Province"] , colTitle: ["YEAR(Ship Date)"] }
  ];
objData.tLoadData.loadCfg([], jsonFormated);

Configure column header information

var arrForCol={};
objForCol["TOTAL SALES"] = 1;
objForCol["VS. LY%  "] = 2;
objForCol["VS. BUD%"] = 3;
var jsonFormated = [
    { wsName: "Cat_Sales", valueName: "Measure Values", rowTitle: ["City","State/Province"] , colTitle: ["Sub-Category","Category"] },
    { wsName: "Sales_Gth", valueName: "Measure Values", rowTitle: ["City","State/Province"] , colTitle: ["YEAR(Ship Date)"] }
  ];
objData.tLoadData.loadCfg(arrForCol, jsonFormated);

LoadCol(funCB)

Function funCB Callback function

Get column header

    objData.tLoadData.LoadCol(function() {
    	console.log(objData.tLoadData);
    });

ConvToTable(funCB)

Function funCB Callback function

Get content value

    objData.tLoadData.ConvToTable(function() {
    	console.log(objData.tLoadData);
    });

Content

sortData(intCol,funCB)

number intCol Column position
Function funCB callback function

Global sort based on the data for a specific column.