Tableau 简明教程

Tableau - Paged Workbook

分页工作簿用于为维度或度量的不同值在不同页面中保存数据的视图。一个常见的示例是查看每种产品类型在特定销售区域中相对于其他产品类型的表现情况。由于每种产品类型的不同值都存储在一个单独的页面中,我们可以一次查看它们或将它们视为一个值范围。

A paged workbook is used to save the view of the data in different pages for different values of the dimension or measure. A common example is to see how each type of products have performed against each other in a specific sales region. As each of the values of product type is stored as a separate page, we can view them one at a time or see it as a range of values.

Creating Paged Workbook

分页工作簿包含将字段放置在页面架上的工作表。考虑研究产品不同子类别在不同地区的利润的示例。以下为步骤。

The paged workbook contains worksheets which have fields put in the page shelf. Consider an example of studying the profit of various sub-category of products in different regions. Following are the steps.

Step 1 − 创建具有两个维度和一个度量的条形图。在此情况下,将度量“利润”拖动到列架,将维度“子类别”和“地区”拖动到行架,如下图所示。

Step 1 − Create a bar chart with two dimensions and one measure. In this case, drag the Measure Profit to the columns shelf and the dimensions sub-category, and Region to the rows shelf as shown in the following screenshot.

paged worksheet 1

Step 2 - 再次将子类别字段拖到页面栏。你将看到自动添加了一个页面控件,就在页面栏的下方。此页面控件提供以下功能,以导航视图中的页面:

Step 2 − Drag the Sub-Category field again to the page shelf. You will see that a page control is automatically added, just below the Pages shelf. This page control provides the following features to navigate through the pages in a view −

  1. Jump to a specific page

  2. Manually advance through the pages

  3. Automatically advance through pages

在此示例中,我们将了解如何跳转到特定页面以及如何获取页面的自动显示。要转到特定页面,请单击页面控件上的下拉列表,然后选择配件。出现以下屏幕截图所示的图表。

In this case, we will see how to jump to a specific page and how to get the automatic display of pages. To go to a specific page, click on the drop-down on the page control and select Accessories. The chart seen in the following screenshot appears.

paged worksheet 2

Step 3 - 对于页面的自动显示,保持显示历史记录复选框被选中,然后单击播放按钮。然后可以看到子类别的不同页面自动播放。当前子类别值显示为暗色,而前值则以浅色显示。以下屏幕截图对此进行了说明。

Step 3 − For automatic display of pages, keep the show history checkbox ticked and click the play button. You can then see an automatic play of different pages of sub categories. While the current Sub-Category value is shown with a dark color, the previous values are shaded with light color. The following screenshot illustrates this.

paged worksheet 3