Table Chart

Create table-style charts

Render Types

Table charts support the following render types. In the raw table, you can select fields and filter rows. In the aggregated table, you can also aggregate values.

Raw Table	Aggregated Table

Specifications

Source Types

Table charts have two source types. Depending on the selected source type, the aggregation and display behavior differs.

Source Type	Description	Column Roles
Raw data (raw table)	Display retrieved rows as-is	Select columns to display
Aggregated data (aggregated table)	Group and aggregate	Group (dimension) and values (metrics)

Tips

Image Display

By specifying an image URL in a column and turning on "Enable" in "Advanced" > "Column Settings" > "Image URL Preview", the image at the specified URL will be displayed in the table chart.

Link Display

By specifying a URL in a column and enabling "Enable link URL" under "Advanced" > "Column Settings", the table chart will display the URL as a link that opens in a new tab.

Creating Parameterized Links from Table Charts to Reports

By dynamically generating URLs in SQL queries, you can pass data from each row of the table as parameters to another report page.

1. Creating a report and obtaining the URL

   • Set parameters in the destination report and obtain the URL from the browser's address bar.

     • Example URL: https://app.codatum.com/workspace/{workspace_id}/report/{report_id}/{page_id}

   • How to check parameter ID: Note the ID of the parameter widget in the report (e.g., 68f369edf5e6f69036b8872d)

2. Creating a URL column in SQL

   • Use the CONCAT function to generate a URL containing parameters from each row's data and insert it into the chart.

   • Example with a single parameter (country name):

     CONCAT(
       'https://app.codatum.com/workspace/{workspace_id}/report/{report_id}/{page_id}?cdm.params.{parameter_id}=',
       country  --- Column name to pass as parameter
     ) AS link

3. Enabling links in table chart

   • Table chart settings → Column settings → Target column → Turn on "Enable link URL".

Notes

• Replace the country part with the database column name you want to pass as a parameter

• You cannot reference the current value of parameter widgets in SQL (only fixed values or column values)

• When a user clicks a cell, the report opens in a new tab

• For detailed information on parameter settings, see here