> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/tables.md).

# Tables

Tables let you build your own tables from any dimensions, time levels and metrics, save them in reports shared with your whole account and add them to dashboards.

{% hint style="info" %}
Tables are in **Beta**.
{% endhint %}

Tables are for the overview you would otherwise rebuild in a spreadsheet every week. You choose what goes into the rows, the columns and the values, and Roivenue keeps the table up to date. Tables are saved in **reports**. A report can hold up to five tables, and everyone in your account can open it, so there is no need to recreate the same table for each user.

Use Tables when you want to:

* See several metrics for the same breakdown side by side, for example Conversions and Net Revenue by campaign and month.
* Compare periods in one view.
* Keep a fixed set of tables for a regular meeting or report.

To open the page, go to **Tables** in the left navigation. The menu lists all reports in your account. Click **New Table Report** to create one.

***

### How to read a report

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FfdRFEVALl1jRWaNIVmEN%2F01-table-report.png?alt=media&amp;token=2dc2da1a-0c1b-49b5-985a-6d24b86bfda7" alt=""><figcaption></figcaption></figure>

1. **Report actions:** **Save** the view as a bookmark, share a link, add a **New Table**, choose the attribution model and the date range. The ⋮ menu lets you rename, duplicate or delete the report.
2. **Table actions:** **Expand All** or **Collapse All** rows, **Export** the table to Excel, **Add To Dashboard** and the ⋮ menu with **Edit** and **Delete table**.
3. **Rows:** the dimensions you chose for rows. In the nested view, click the arrow to open the next level. The number in brackets shows how many items the next level has.
4. **Columns:** the dimension or time level you chose for columns, for example months.
5. **Values:** the metrics for each row and column. The heat map colours the cells from low to high values.
6. **Total** and **Average** rows for all rows in the table, not only the current page.

Click a column name to sort the table, and use the filter field under the column name to filter it. **Page Size** sets how many rows you see.

The date range, the attribution model and the **Filter Panel** apply to all tables in the report.

***

### How to create a table

Click **New Table Report** in the menu, or **New Table** in an existing report. In a new report, enter the **Report Name** first. The report is visible to all users in your account.

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FVFFCw5pz1UXv9CM50WgS%2F02-edit-table.png?alt=media&amp;token=63591a2c-fd6b-4271-9f7e-22b4a3713fea" alt=""><figcaption></figcaption></figure>

1. **Table Name:** the name shown above the table.
2. **Table View:**
   * **Nested** shows the rows in levels. Each row dimension is one level, and you open the levels with the arrows.
   * **Flat** shows all rows at one level. Each row combines all row dimensions.
3. **Rows** (required): the dimensions for rows, for example **Source/Medium/Campaign** and **Site**.
4. **Columns** (optional): a dimension or a time level for columns. Under **Date granularity**, you can choose **Day**, **Week**, **Month**, **Quarter** or **Year**.
5. **Values** (required): the metrics. The **Heat Map** switch turns the colour scale on or off for each metric.

Drag the handle on the left to change the order, and click the bin icon to remove an item. Click **Create** or **Save** to finish.

{% hint style="info" %}
**Tip:** Start small. Each dimension and metric multiplies the number of cells, so a table with many items loads slower. Add more once the basic table works.
{% endhint %}

***

### How to compare periods

Turn on **Compare** in the date picker and choose the period to compare with. Each cell then shows the value, the compared value and the change. Use the switch in the table to show the change as an absolute value or as a percentage.

***

### How to save and share a report

* **Save** creates a bookmark of the report. The bookmark saves only the attribution model, the date range and the Filter Panel. The tables stay linked to the original report: changes in the report show in the bookmark, and changes to the tables made from the bookmark also change the report. See [Bookmarks](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/bookmarks).
* **Share** copies a link to the report.
* **Add To Dashboard** adds a table to a dashboard as a copy with its current settings. Later changes in the report do not reach the dashboard widget, and changes in the widget do not change the report. See [Dashboard](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/dashboard).

***

### Who can create and edit reports

Only users with the **Editor** or **Admin** role can create, edit, rename, duplicate or delete reports and tables. Other users can open the reports and work with filters and the date range. There are no private reports: every report is visible to the whole account.

If someone deletes a report by mistake, an editor or admin can restore it.

***

### Limits

| Limit                            | Value                    |
| -------------------------------- | ------------------------ |
| Tables in one report             | 5                        |
| Items in Rows, Columns or Values | 12 each                  |
| Date range                       | One for the whole report |

Sorting and column filters reset on the next visit. Very large tables are not shown. Roivenue shows an error instead, so you can remove some dimensions or metrics, or narrow the data with the Filter Panel.

***

#### FAQ

<details>

<summary>1. Why can't I create or edit a report?</summary>

You need the **Editor** or **Admin** role. Users with other roles see the reports, but the editing buttons are disabled. Ask an admin of your account to change your role. See [Users Management](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/users-management).

</details>

<details>

<summary>2. What does "Incomplete period selected" mean?</summary>

The date range does not cover whole periods of the time level in the columns, for example it starts in the middle of a month while the columns show months. The table shows data strictly for the selected dates, so the first and last columns contain only part of the period.

</details>

<details>

<summary>3. Why does my table show an error instead of data?</summary>

The table has more dimension values and metrics than it can display. Remove some dimensions or metrics, or narrow the data with the Filter Panel.

</details>

<details>

<summary>4. Why did my sorting and filters disappear?</summary>

Sorting and column filters are not saved. They reset the next time you open the report. To keep a filtered view, use the Filter Panel and save the report as a bookmark.

</details>

<details>

<summary>5. I changed a table, but my dashboard still shows the old version. Why?</summary>

A table on a dashboard is a copy made when you added it. Later changes in the report do not update it. Add the table to the dashboard again and remove the old widget.

</details>

<details>

<summary>6. Can I use different date ranges for tables in one report?</summary>

No. All tables in a report use the date range of the report. To compare periods, use **Compare** in the date picker, or put a time level such as **Month** into the columns.

</details>

<details>

<summary>7. Why can't I find a dimension or a metric?</summary>

Some dimensions and metrics are hidden on certain pages. Go to **Data → Dimensions** or **Data → Metrics**, open the settings of the item and check whether **Hide in Table Reports** is on.

</details>
