1 files changed, 9 insertions, 0 deletions
diff --git a/app/models/product_analytics_event.rb b/app/models/product_analytics_event.rb
index 579ea88c272..d2026d3b333 100644
--- a/app/models/product_analytics_event.rb
+++ b/app/models/product_analytics_event.rb
@@ -20,10 +20,19 @@ class ProductAnalyticsEvent < ApplicationRecord
     where('collector_tstamp BETWEEN ? AND ? ', today - duration + 1, today + 1)
   }
 
+  scope :by_category_and_action, ->(category, action) { where(se_category: category, se_action: action) }
+
   def self.count_by_graph(graph, days)
     group(graph).timerange(days).count
   end
 
+  def self.count_collector_tstamp_by_day(days)
+    group("DATE_TRUNC('day', collector_tstamp)")
+      .reorder('date_trunc_day_collector_tstamp')
+      .timerange(days)
+      .count
+  end
+
   def as_json_wo_empty
     as_json.compact
   end