Introducing a new visualization similar to tabular reporting in a Pivot Table. Simply add your Measures and Compound Measures to provide the calculation values, then pivot based on Breakdowns and Segments.
Use Cases for Data Table:
Only interested in measures aggregated and side by side, no lines/bars.
Allows for multiple breakdowns (up to 5) similar to a Pivot Table in Excel or Tableau.
See ALL the data
Building a Data Table
Data Table is similar to Query in that it's made of Measures, Compound Measures and the standard filters/breakdown/segments.
Build the Measures you want to see aggregated directly within the data table.
Select Saved Measures by clicking "Measure Options" and then "Add Named Measure" and select the one you want to use.
Note that you are only able to build Compound Measures in Query. Once you Save them you'll be able to select them in Data Table.
Data Table Results
Once executed the result will be a pivoted view of:
Rows for each breakdown group you've applied.
Columns for each Measure you've selected
Additional columns for any Segments you've applied.
You are able to search, sort, and format the items within the Data Table. You can also Rename the columns to make sure it's clear what the Measure represents.
Compare in Data Table
In the Data Table report, you can compare a measure against its previous day, week, month, quarter, year, or another custom date range.
When constructing your Data Table:
Select a Compare range next to your report date picker.
Execute your report
You'll see a 'Previous' column containing the Compare date range data and a 'Current' column containing the report date picker data.
You can also toggle on "Show % Change" above the table to visualize the change over time as a % with color formatting.
Additional Options
You are also able to:
Add the Data Table to a Dashboard
Export the Table to a CSV
Reset any sort or search filters applied
