Total amount collected per day - Twikey SQL Query - Peliqan

Total amount collected per day

SQL query for Twikey

Calculate the total amount collected per day from the transactions table.

SELECT DATE(transaction_date) AS day, SUM(amount) AS total_amount FROM transactions GROUP BY day

Twikey data model

Mandates

Transactions

Collections

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.