Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

02/01/22 13:54:47 (3 years ago)

Author:

191215

Comment:

--

AdvancedReports

@@ -5 +5 @@
 {{{#!sql
 select 
-        SUM(t.stripe_price) from transactions t
-        inner join offers o on
-                o.artist_id  = 6
-                and 
-                t.offer_id = o.id 
-        where extract (year from t.created_at) = extract (year from now() - interval '1 year');
+        o.artist_id,
+        SUM(t.stripe_price)
+from transactions t 
+inner join offers o on 
+                t.offer_id = o.id 
+where 
+        extract (year from t.created_at) = extract (year from now() - interval '1 year')
+group by o.artist_id 
 }}}