Datasets
Saved Views
SELECT
date_trunc('month', transaction_date) AS month,
SUM(amount) AS total_revenue
FROM financial_transactions
WHERE transaction_type = 'revenue'
GROUP BY 1
ORDER BY 1 DESC
LIMIT 12;
Revenue by Month
Chart will appear here when query is run