Note

coder · mtojek · Sep 26, 2023 · Sep 21, 2023 · Sep 21, 2023 · Sep 21, 2023
commit f955f7f129887609eb6cb35a8de660ff37ec90e9
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/insights.sql b/coderd/database/queries/insights.sql
@@ -25,6 +25,10 @@ ORDER BY user_id ASC;
 -- GetUserActivityInsights returns the ranking with top active users.
 -- The result can be filtered on template_ids, meaning only user data from workspaces
 -- based on those templates will be included.
+-- Note: When selecting data from multiple templates or the entire deployment,
+-- be aware that it may lead to an increase in "usage" numbers (cumulative). In such cases,
+-- users may be counted multiple times for the same time interval if they have used multiple templates
+-- simultaneously.
 WITH app_stats AS (
 	SELECT
 		s.start_time,