Freeform table
In Analysis Workspace, a Freeform Table is the foundation for interactive data analysis. You can drag and drop a combination of components into rows and columns to create a custom table for your analysis. As each component is dropped, the table updates immediately, so you can quickly analyze and dig deeper.
Build a simple Freeform table
You start with an empty Freeform Table.
If you drop the Visits metric on the Drop a metric here (or any other component), the Freeform Table automatically populates with visits per day for the calendar period you selected.
If you then drop the Page dimension to replace the Day dimension column, the Freeform table automatically reflects visits for each page.
You can then break down, for example, the category:5 page by dropping the Marketing Channel dimension on the category:5 row.
Automated tables
As illustrated above, the quickest way to build a table is to drop components directly into a blank project, panel, or freeform table. A freeform table will automatically be built for you in a recommended format. Watch the tutorial.
Freeform table builder
If you prefer to add several components to your table first, then render the data, you can enable Freeform Table Builder. With the builder enabled, you can drag & drop in many dimensions, breakdowns, metrics, and segments to build tables that answer more complex questions. Data will not update on-the-fly, it updates once you click Build.
Table interactions
You can interact with and customize a freeform table in a variety of ways:
-
Rows
- You can fit more rows into a single screen by adjusting the project’s view density.
- Each dimension row can show up to 400 rows, before pagination occurs. Click the number next to “Rows” to show more rows on a page. Navigate to a different page using the page arrow in the header.
- Rows can be broken down by additional components. To breakdown many rows at once, simply select multiple rows and then drag the next component on top of the selected rows. Learn more about breakdowns.
- Rows can be filtered to show a reduced set of items. Additional settings are available under Row settings.
-
Columns
- Components can be stacked within columns to create segmented metrics, cross-tab analysis and more.
- Each column’s view can be adjusted under the column settings.
- Several actions are available through the right-click menu. The menu provides different actions depending on if you click the table header, rows, or columns.
Export Freeform Table data
Learn more about all data export options for Analysis Workspace.
- Right-click > Copy data to clipboard exports the displayed table data. If a table selection is made, this option will say Copy selection to clipboard. The Ctrl+C hotkey also copies selected data.
- Right-click > Download data as CSV downloads the displayed table data as a CSV. If a table selection is made, this option will say Download selection as CSV.
- Right-click > Project > Download items as CSV exports up to 50,000 dimension items for the selected dimension.
Learn more about all data export options for Analysis Workspace.
Videos
Freeform table builder overview:
Freeform table filters:
Freeform table totals: