Changes between Initial Version and Version 1 of AdvancedReport9

Timestamp:

12/28/25 23:17:39 (6 days ago)

Author:

211101

Comment:

--

AdvancedReport9

@@ +1 @@
+===== Просечно трошење во последните 3 дена за корисник
+Просечно дневно трошење за последните 3 дена за одреден корисник:
+{{{#!sql
+SELECT 
+    AVG(daily_spending) AS average_spending_last_3_days
+FROM (
+    SELECT 
+        t.date::date AS transaction_date, 
+        SUM(tb.spent_amount) AS daily_spending
+    FROM 
+        transaction t
+    JOIN transaction_breakdown tb ON t.transaction_id = tb.transaction_id
+    JOIN transaction_account ta ON tb.transaction_account_id = ta.transaction_account_id
+    WHERE 
+        ta.user_id = 101 -- ID на конкретниот корисник
+        AND t.date >= CURRENT_DATE - INTERVAL '2 DAY'
+        AND t.date < CURRENT_DATE + INTERVAL '1 DAY'
+    GROUP BY 
+        t.date::date
+) daily_totals;
+}}}