This document contains frequently asked questions that arise when working with the Pivot Table widget in TapClicks. You can quickly navigate to a particular FAQ by using the table of contents below.
What is the Pivot Table widget?
How is this different from the existing Data Grid widget?
Does this change how metrics are calculated?
Who is this feature designed for?
Can pivot tables be viewed in both Dashboards and Report Studio?
Can data be compared across time?
Are totals supported?
Is Excel still needed for pivot analysis?
Is this replacing the existing Data Grid widget?
Is this included in existing TapClicks reporting capabilities?
What is the Pivot Table widget?
The Pivot Table widget is a reporting capability that allows data to be organized and analyzed across both rows and columns in a pivot-style format directly within TapClicks Dashboards and Report Studio.
How is this different from the existing Data Grid widget?
The Data Grid presents data in a fixed tabular format, while the Pivot Table widget allows flexible multi-dimensional analysis by placing dimensions across both rows and columns.
Does this change how metrics are calculated?
No. The Pivot Table widget retains existing TapClicks metric behavior and only changes how the data is organized and displayed.
Who is this feature designed for?
This feature is ideal for agencies, media companies, performance marketing teams, and analysts who regularly work with large datasets and need deeper reporting flexibility.
Can pivot tables be viewed in both Dashboards and Report Studio?
Yes. The Pivot Table widget is available across both experiences for consistent reporting workflows.
Can data be compared across time?
Yes. You can use date-based dimensions, such as month, as column dimensions to analyze performance trends.
Are totals supported?
Yes. The Pivot Table widget supports grand totals for both row and column dimensions. Totals are currently supported for numeric values only; decimal and percentage fields do not display a total.
Is Excel still needed for pivot analysis?
No. The Pivot Table widget brings pivot-style analysis directly into TapClicks, reducing reliance on spreadsheet exports for many common reporting workflows.
Is this replacing the existing Data Grid widget?
No. The Pivot Table widget is a reporting option designed for advanced analytical use cases, while the Data Grid remains available for standard tabular reporting needs.
Is this included in existing TapClicks reporting capabilities?
Yes. The Pivot Table widget is a core reporting enhancement rather than a separate standalone add-on.