Create a Metric using Custom SQL

This guide provides a step-by-step approach to utilizing custom SQL for creating metrics, which can enhance your data analysis capabilities.

1. Access Custom SQL:

• In the create metric page, select "Custom Query" option

• Click the "Write Query" button

1. Query Execution:

• Write your query and use "Format Query" button to properly format your SQL

• Click "Run Query" to execute

1. View the chart:

1. Preview:

• Click on Preview icon located near the table name to view the SQL data in tabular format

• Use features like search, sort, and pagination if needed

1. Edit Custom query:

Click on the "</> Edit" icon to make changes in the custom SQL query.