Calculated fields based on existing data - Google Sheets SQL Query - Peliqan

Calculated fields based on existing data

SQL query for Google Sheets

Calculate the total revenue as the product of unit price and quantity sold for each product.

SELECT product_id, product_name, unit_price, quantity_sold, (unit_price * quantity_sold) AS total_revenue FROM products;

Google Sheets data model

Data model coming soon!

Ready to get instant access to all your company data ?

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.