Changes between Initial Version and Version 1 of AdvancedReport8

Timestamp:

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

Author:

211101

Comment:

--

AdvancedReport8

@@ +1 @@
+===== Просечно трошење во последните 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
+    WHERE 
+        t.date >= CURRENT_DATE - INTERVAL '2 DAY'
+        AND t.date < CURRENT_DATE + INTERVAL '1 DAY'
+    GROUP BY 
+        t.date::date
+) daily_totals;
+}}}