Explains what the feature is or what its benefits are to the user or customer.
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.
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.
- 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.
- 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 video