1 files changed, 29 insertions, 0 deletions
diff --git a/lib/gitlab/usage/metrics/instrumentations/unique_active_users_metric.rb b/lib/gitlab/usage/metrics/instrumentations/unique_active_users_metric.rb
new file mode 100644
index 00000000000..9da30db05dd
--- /dev/null
+++ b/lib/gitlab/usage/metrics/instrumentations/unique_active_users_metric.rb
@@ -0,0 +1,29 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module Usage
+    module Metrics
+      module Instrumentations
+        class UniqueActiveUsersMetric < DatabaseMetric
+          operation :count
+          relation { ::User.active }
+
+          metric_options do
+            {
+              batch_size: 10_000
+            }
+          end
+
+          def time_constraints
+            case time_frame
+            when '28d'
+              monthly_time_range_db_params(column: :last_activity_on)
+            else
+              super
+            end
+          end
+        end
+      end
+    end
+  end
+end