Pivot tables let viewers summarize query results by dragging fields into rows, columns, values, and filters.
Aggregations
Pivot tables support common aggregations:
- Count
- Sum
- Average
- Minimum
- Maximum
Fields
Fields come from chart query results. Choose fields that are understandable to dashboard viewers and have values suitable for grouping or aggregation.
Filters
Pivot filters help narrow data inside the pivot table. Use them for categories, statuses, periods, or other fields where viewers need focused analysis.
Embedded pivot tables
Dashboard embed settings can allow or disable pivot tables. Enable embedded pivots only when external viewers should be able to explore the underlying query result.
Tips
- Keep source queries reasonably scoped.
- Use readable aliases for query columns.
- Use numeric fields for value aggregations.
- Use categorical or date fields for rows and columns.