In Analysis Workspace, a Freeform Table is not merely a data table, but also an interactive visualization. You can drag and drop a combination of components into the rows and columns to create a custom table for your analysis. As each component is dropped, the table will update immediately so you can do rapid analysis.
You can customize the table in a variety of ways:
- Each dimension row can show up to 400 rows, before pagination occurs. You can fit more rows into a single screen by adjusting the project’s view density.
- 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.
- 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.
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 will update once you click Build.
Table Builder is a time-saving option when you have a complex question to ask of the data, and you have an idea of the table you want to construct to answer your question. Other advantages of the table builder include the ability to:
- Arrange the table in the exact format you need, without having to wait for each action to render.
- Quickly perform up to 4 levels of breakdowns.
- Define the Row and Breakdown settings for every table row and dimension column.
- Breakdown by Position for every level of the table by default (in traditional Freeform Tables, the default is Breakdown by Item.)
- Manually order static rows in the table. For example, if you want metric rows to appear in a certain order.
- Preview the format of your table prior to rendering real data.
Watch the Freeform Table Builder in action here.
Export Freeform Table data
The data in a freeform table can be copied out of Analysis Workspace in a few ways:
- Right-click the table header and select Copy to Clipboard. This will export the full (visible) table.
- Highlight specific cells in the table, right-click and select Copy to Clipboard, or use the Ctrl + C hotkey.
- Project > Download CSV. This will export all visible tables in the project as a CSV.