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 will update immediately so you can do quickly analyze and dig deeper.

Freeform Table showing components in rows and columns including Visits and Online Orders for multiple web pages.

Automated tables

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.

A new Panel with the visits component dropped onto the working space.

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 filters to build tables that answer more complex questions. Data will not update on-the-fly, it will update once you click Build.

A Freeform Table Builder showing

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 filtered 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 will export up to 50,000 dimension items for the selected dimension.

Learn more about all data export options for Analysis Workspace.

Freeform Table showing the export options and Copy data to clipboard selected.

recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79