Switch to aggregated data（切换到聚合数据）¶

Some boards that allow you to calculate aggregate metrics have an option to pivot. This switches your working dataset to the aggregate data computed in that board, instead of the original dataset. Any boards that follow will use the new aggregate dataset.

The new dataset will include all the columns you selected in the aggregate board, as well as one column for every aggregate. The dataset will not include any grand total rows or columns.

switch-to-pivot

To improve performance, Contour will attempt to cache the aggregate data computed in the pivot table after you switch to aggregated data. If caching of aggregate data is successful, you will see a tick mark in the bottom-right of the board (as illustrated below):

An image of the footer of the Contour pivot table board. On the bottom right of the board, there is a circular tick mark. A tooltip over the tick mark reads: 'Cached for faster downstream computation.'

:::callout{theme="neutral"} Because commas are not supported by Contour within column names, using Contour's Pivot Table board on a column whose values include commas is not recommended. Consider using an Expression board to modify the values of that column prior to use of the Pivot Table board. :::

中文翻译¶

切换到聚合数据¶

某些允许您计算聚合指标的面板提供了数据透视（pivot）选项。启用该选项后，您的工作数据集将切换为该面板中计算的聚合数据，而非原始数据集。后续的所有面板都将使用这个新的聚合数据集。

新的数据集将包含您在聚合面板中选择的所有列，以及每个聚合指标对应的列。该数据集不会包含任何总计行或总计列。

switch-to-pivot

为提升性能，Contour 会在您切换到聚合数据后，尝试缓存数据透视表中计算出的聚合数据。如果聚合数据缓存成功，您将在面板右下角看到一个勾选标记（如下图所示）：

Contour 数据透视表面板底部的图片。面板右下角有一个圆形勾选标记。勾选标记上的工具提示显示：'已缓存，可加速下游计算。'

:::callout{theme="neutral"} 由于 Contour 不支持在列名中使用逗号，因此不建议对值包含逗号的列使用 Contour 的数据透视表面板。建议先使用表达式（Expression）面板修改该列的值，然后再使用数据透视表面板。 :::