Skip to main content

 

ThoughtSpot

About pivot tables

Pivot table video

 

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

Pivot tables in ThoughtSpot use the well known drag-and-drop interface. Creating a pivot table enables exploring alternate visualization of data in a wide table. The basic idea is that some data is easier to consume when laid out horizontally, while others, vertically.

Previously, ThoughtSpot used a pivot keyword to select which fields can be columns and which can be rows, thus moving columns to be rows and vice versa. Now, the pivot table is a chart type.

Figure: Pivot table chart type

Choose Pivot Table under Select Chart Type to view your search as a pivot table. Add rows, measures, and columns to the search bar and restructure your table by moving these values under Configure Chart or by dragging and dropping them.

Figure: Chart axes: rows, measures, columns

File:01_The_Basics/end_user_guide_bookmap/030/060/pivot_table_rows_measures_columns.png

Some additional details about pivot tables include:

  • Pivot tables show the grand totals for columns and rows.
  • You can toggle on the Heatmap mode found under Configuration Options to add color coordination to your data.

    Figure: Heatmap mode enabled

    File:01_The_Basics/end_user_guide_bookmap/030/060/pivot_table_heatmap_mode.png
  • Click a column or row to expand it. Additionally, you can expand or collapse all by right clicking the arrow on the top left of a cell.

    Figure: Expand or collapse all option

    File:01_The_Basics/end_user_guide_bookmap/030/060/pivot_table_expand_collapse_all.png
  • When you pin a pivot table to a pinboard, it will retain your expansion settings.

The pivot table chart type has these limitations:

  • Pivot table is not available if the dataset contains more than 100,000 rows.
  • Columns with cardinality beyond 100 are grouped into {Other}.
  • Show underlying data menu is unavailable.
  • Conditional formatting is not functional.
  • Was this article helpful?