Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/23/26 20:20:24 (7 days ago)

Author:

231136

Comment:

--

AdvancedReports

@@ -195 +195 @@
 )
 SELECT 
-    CONCAT(EXTRACT(YEAR FROM oy.year_start),'-',m.month_name) AS month,
+    CONCAT(EXTRACT(YEAR FROM oy.year_start),'-', m.month_name) AS month,
     COALESCE(u.full_name,'n/a') AS artist_name,
-    COALESCE(mp.max_month_counter,0) AS monthly_listens
+    COALESCE(mp.max_month_counter, 0) AS monthly_listens
 FROM months m
 LEFT JOIN most_popular mp ON mp.month=m.month_num
@@ -242 +242 @@
     SELECT
         u.full_name,
-        CONCAT(om.prev_period_start::DATE, ' | ',om.prev_period_end::DATE) AS previous_period,
+        CONCAT(om.prev_period_start::DATE, ' | ', om.prev_period_end::DATE) AS previous_period,
         last_period_count,
-        CONCAT(om.this_period_start::DATE, ' | ',om.this_period_end::DATE) AS this_period,
+        CONCAT(om.this_period_start::DATE, ' | ', om.this_period_end::DATE) AS this_period,
         this_period_count,
         ROUND(((CAST(this_period_count AS DOUBLE PRECISION) - last_period_count) / NULLIF(last_period_count, 0)) * 100) AS pct_change