Pivot tables let you explore an alternate, customizable visualization of your data, mixing horizontal and vertical layout in the same table.Pivot tables are charts that let you explore an alternate visualization of your data in a wide, customizable table. With pivot tables, you can use the same table to visualize some of your data horizontally, and some vertically. To visualize your search as a pivot table, click the change visualization icon and select pivot table. You need at least one attribute and one Measure in your search. Restructure your pivot table by dragging and dropping Measures and attributes under edit chart configuration, or by dragging and dropping column headings on the table itself. Right-click a row or column heading to open a contextual menu, letting you exclude or include values, drill down, show underlying data, SpotIQ analyze, or sort.
Sort
Right-click a row or column heading, subheading, or a Measure or attribute name, and select Sort. You can also sort from the search bar:Limitations
- You can only sort on one attribute at a time.
- Sorting by a Measure sorts both columns and rows.
- Sorts don’t save when you save a pivot table.
Expanding or collapsing columns and rows
Click a column or row heading to expand it. You can also expand or collapse all columns and rows by right-clicking the arrow in the top-left of a cell. Pinning a pivot table to a Dashboard retains your expansion settings.Display totals
You can see your data as a percent of a row or column total, or as a percent of the grand total. Grand totals aggregate all the data in your pivot table. Click the edit chart configuration icon, then settings at the bottom of the panel, and choose whether you want data shown as a percent of a row total, column total, or grand total. You only see a 100% value when grand total rows is enabled. Select Pivot Summaries in the Settings menu to see row and column totals.Format row headers
Select Compact row headers in the Settings menu for a more compact, tree-style layout. Change the type of total shown for an aggregated Measure from the header menu that appears when you click a header’s more icon.Heatmap mode
Turn on heatmap mode to see which Measures contribute more to the total than others within the table. Click edit chart configuration, then settings, and select heatmap mode.Pivot table limitations
- Displays a maximum of 100k rows — a query returning more can’t be visualized as a pivot table.
- Doesn’t support conditional formatting.
- Doesn’t support use of group aggregation functions.
- If the underlying query contains the
toporbottomkeyword, column and row summaries aren’t accurate. - You can’t filter aggregated columns or columns with aggregated formulas.