Custom SQL Console

1. Access the Custom SQL

On the Create Metric page, select the "Custom Query" option.

1. Writing SQL Scripts

• Enter your SQL code and click "Run Query" to generate the chart.

• (Optional) Use the "Format Query with AI" option to ensure proper formatting of your query.

• Query Result displays the data returned for your SQL query. This data can be downloaded as a csv file if required.

1. Usage Example: Below is an example SQL code to visualize the value and quantity of all orders based on the products ordered.

SELECT
  AVG("main_procurement_mgmnt_data"."order_value") AS "Avg Order Value",
  AVG("main_procurement_mgmnt_data"."order_quantity") AS "Avg Order Quantity",
  "main_procurement_mgmnt_data"."product" AS "Product"
FROM
  "main"."procurement_mgmnt_data" AS "main_procurement_mgmnt_data"
GROUP BY
  "Product"
LIMIT
  100

1. Output of the above SQL Code: