Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

02/13/24 22:16:37 (9 months ago)

Author:

201136

Comment:

--

AdvancedReports

@@ -55 +55 @@
 
 }}}
+
+=== **Извештај за активни корисници според тромесечије**
+{{{#!sql
+
+SELECT DATE_TRUNC('quarter', d.date) AS QuarterStart,
+       COUNT(DISTINCT uhd.uID) AS num_users_with_activity
+FROM _Day d
+LEFT JOIN UserHasDays uhd ON d.dID = uhd.dID
+LEFT JOIN DayHasWorkout dw ON d.dID = dw.dID
+LEFT JOIN DayHasMeal dm ON d.dID = dm.dID
+WHERE d.date >= CURRENT_DATE - INTERVAL '1 year'
+GROUP BY QuarterStart
+ORDER BY QuarterStart;
+
+
+}}}