Table Chart

• Left Panel

• Center Panel

• Right Panel

Left Panel

• Chart Source

• Metrics and Columns

Chart Source

Chart Source lets you control how a chart is powered. You can edit the dataset, swap it with another, or view the underlying SQL query for analysis.

• Edit Dataset

• Swap Dataset

• View in SQL Lab

Figure: Chart Source

Edit Dataset

Lets you make changes to the underlying dataset definition used by the chart.
It is accessible only for Admins, for other users this option is grayed.

Swap Dataset

Allows you to replace the dataset currently powering the chart with another dataset. For more information, refer to Field Description.

Note

Warning! Changing the dataset may break the chart if the chart relies on columns or metadata that does not exist in the target dataset.

Figure: Swap Dataset

Field Description

View in SQL Lab

Opens the raw SQL query that powers the dataset/chart in a SQL editor.
Figure: View SQL in Lab

Lets you to perform the below actions:

• Inspect the actual query running behind the visualization

• Modify or extend the SQL for more complex logic

• Validate the query results before applying them back into the dataset or chart

Useful for power users who need transparency and control over the exact query execution.

Metrics and Columns

Enables you to drag and drop the Metrics and Columns to the center panel of Edit Report Dashboard.
Hover on the SQL icon to view the SQL Expression.


Figure: Columns and Metrics

Center Panel

• Data

• Customize

Data

Data section displays 3 configurable sections for Table chart, as described in the below sections:

1. Chart Selection – choose the visualization type for displaying data.
   Click View all charts to view and select the required visualization type.

   

   Figure: Visualization Type
   

2. Query:  view or modify the data query powering the chart.

   Configure the Query Mode (Aggregate or Raw Records).

   Notes

   • Aggregate: Groups data using metrics and dimensions to show summarized results.

   • Raw Records: Displays the underlying row-level data without aggregation, useful for detailed record analysis.

   

   Figure: Query

   Field	Description
   Dimensions	Dimensions contain qualitative values such as names, dates or geographical data. Use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.
   Metrics	Select one or many metrics to display. You can use an aggregation function on a column o write custom SQL to create a metric.
   Percentage Metrics	Select one or many metrics to display, that will be displayed in the percentages of total. Percentage metrics will be calculated only from data within the row limit. You can use an aggregation function on a column or write custom SQL to create a percentage metric.
   Filters	Drag and drop columns or metrics here in the Filters.
   Sort Query by	Orders the query result that generates the source data for this chart. If a series or row limit is reached this determines what data are truncated. If undefined, defaults to the first metric (where appropriate).
   Server Pagination	Select Server Pagination to enable server side pagination of results.
   Row Limit	Limits the number of rows that are computed in the query that is the source of the data used for this chart.
   Show Summary	Show total aggregations of selected metrics. Note that row limit does not apply to the result.

3. Time Comparison: compare results across different time ranges for trend analysis.

Customize

Click on the customize section  to view the configuration of other options and visual formatting.

Figure: Customize

For more information, refer to the following table:

Right Panel

Displays the Table. Based on the selected dimensions, the table is displayed.

Figure: Table display