Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

02/13/24 22:25:13 (9 months ago)

Author:

201136

Comment:

--

AdvancedReports

@@ -71 +71 @@
 
 }}}
+
+=== **Извештај за број на денови вои кои корисниците биле активни според тромесечије**
+{{{#!sql
+
+SELECT uhd.uID,
+       DATE_TRUNC('quarter', d.date) AS QuarterStart,
+       COUNT(DISTINCT DATE_TRUNC('day', d.date)) AS active_days
+FROM _Day d
+JOIN UserHasDays uhd ON d.dID = uhd.dID
+WHERE d.date >= CURRENT_DATE - INTERVAL '3 months'
+GROUP BY uhd.uID, QuarterStart
+ORDER BY uhd.uID, QuarterStart;
+
+
+
+}}}