Changes between Initial Version and Version 1 of AdvancedReport16

Timestamp:

12/28/25 23:19:39 (5 days ago)

Author:

211101

Comment:

--

AdvancedReport16

@@ +1 @@
+===== Трендови на трошење според тагови за корисник
+Сумирање на трошењата според тагови во последните 6 месеци за одреден корисник
+{{{#!sql
+SELECT 
+    tg.tag_name, 
+    DATE_TRUNC('month', t.date) AS month,
+    SUM(tb.spent_amount) AS total_spent
+FROM 
+    tag_assigned_to_transaction tat
+JOIN transaction t ON tat.transaction_id = t.transaction_id
+JOIN transaction_breakdown tb ON t.transaction_id = tb.transaction_id
+JOIN transaction_account ta ON tb.transaction_account_id = ta.transaction_account_id
+JOIN tag tg ON tat.tag_id = tg.tag_id
+WHERE 
+    ta.user_id = 101 -- ID на конкретниот корисник
+    AND t.date >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '6 MONTHS')
+GROUP BY 
+    tg.tag_name, month
+ORDER BY 
+    tg.tag_name, month;
+}}}