Changes between Version 3 and Version 4 of BuildPopularity

Timestamp:

01/29/26 16:48:38 (10 days ago)

Author:

233194

Comment:

--

BuildPopularity

@@ -76 +76 @@
 {{{
 price_tier_builds = 
-  π_{b.id ⇒ build_id, b.total_price,
+  π_{b.id ⇒ build_id, b.user_id,
+     b.total_price,
      CASE 
        WHEN b.total_price < 500 THEN 'Budget'
@@ -87 +88 @@
   )
 
+favorites = 
+  γ_{build_id; 
+     COUNT(DISTINCT user_id) ⇒ favorites_count
+  } (favorite_build)
+
 engagement_stats = 
-  γ_{price_tier; 
-     COUNT(build_id) ⇒ builds_count,
-     AVG(favorites_count) ⇒ avg_favorites,
+  γ_{ptb.price_tier; 
+     COUNT(DISTINCT ptb.build_id) ⇒ builds_count,
+     AVG(COALESCE(f.favorites_count, 0)) ⇒ avg_favorites,
      AVG(rb.value) ⇒ avg_rating,
-     COUNT(DISTINCT user_id) ⇒ unique_builders
+     COUNT(DISTINCT ptb.user_id) ⇒ unique_builders
   } (
-    price_tier_builds ⋈_{price_tier_builds.build_id = rb.build_id} rating_build rb
-    ⋈_{rb.build_id = b.id} build b
+    price_tier_builds ptb
+    ⟕_{ptb.build_id = rb.build_id} rating_build rb
+    ⟕_{ptb.build_id = f.build_id} favorites f
   )
 
 λ_15 (
-  τ_{(builds_count * 2) + (avg_favorites * 3) + (avg_rating * 10) + (unique_builders * 1.5) DESC} (
+  τ_{engagement_score DESC} (
     π_{e.price_tier,
        e.builds_count,
-       e.avg_favorites,
-       ROUND(e.avg_rating, 2) ⇒ avg_rating,
+       ROUND(e.avg_favorites, 1) ⇒ avg_favorites,
+       ROUND(COALESCE(e.avg_rating, 0), 2) ⇒ avg_rating,
        e.unique_builders,
-       (e.builds_count * 2 + e.avg_favorites * 3 + e.avg_rating * 10 + e.unique_builders * 1.5) ⇒ engagement_score
+       ROUND((e.builds_count * 2 + e.avg_favorites * 3 + COALESCE(e.avg_rating, 0) * 10 + e.unique_builders * 1.5), 2) ⇒ engagement_score
     } (engagement_stats e)
   )