Changes between Initial Version and Version 1 of AdvancedReport17

Timestamp:

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

Author:

211101

Comment:

--

AdvancedReport17

@@ +1 @@
+===== Вкупно трошење според тагови
+Вкупно трошење групирано според тагови за тековниот месец
+{{{#!sql
+SELECT 
+    tg.tag_name,
+    SUM(tb.spent_amount) AS total_spent
+FROM 
+    tag tg
+JOIN tag_assigned_to_transaction tat ON tg.tag_id = tat.tag_id
+JOIN transaction t ON tat.transaction_id = t.transaction_id
+JOIN transaction_breakdown tb ON t.transaction_id = tb.transaction_id
+WHERE 
+    EXTRACT(MONTH FROM t.date) = EXTRACT(MONTH FROM CURRENT_DATE)
+    AND EXTRACT(YEAR FROM t.date) = EXTRACT(YEAR FROM CURRENT_DATE)
+GROUP BY 
+    tg.tag_name
+ORDER BY 
+    total_spent DESC;
+}}}