This is an automated email from the ASF dual-hosted git repository.
warren pushed a commit to branch feat/q-dev-logging-dashboard-enrichment
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to
refs/heads/feat/q-dev-logging-dashboard-enrichment by this push:
new 29fcee3a5 fix(q-dev): fix GROUP BY in per-user table to merge
display_name variants
29fcee3a5 is described below
commit 29fcee3a525e151f704c333711281ac46f723491
Author: warren <[email protected]>
AuthorDate: Sun Mar 15 11:24:37 2026 +0800
fix(q-dev): fix GROUP BY in per-user table to merge display_name variants
Remove display_name from GROUP BY so same user_id with different
display_name values gets merged. Use MAX(display_name) in SELECT.
---
grafana/dashboards/qdev_user_report.json | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/grafana/dashboards/qdev_user_report.json
b/grafana/dashboards/qdev_user_report.json
index 68f4b8650..88a12b614 100644
--- a/grafana/dashboards/qdev_user_report.json
+++ b/grafana/dashboards/qdev_user_report.json
@@ -433,7 +433,7 @@
"editorMode": "code",
"format": "table",
"rawQuery": true,
- "rawSql": "SELECT\n COALESCE(display_name, user_id) as 'User',\n
subscription_tier as 'Tier',\n client_type as 'Client',\n SUM(credits_used)
as 'Credits Used',\n SUM(total_messages) as 'Messages',\n
SUM(chat_conversations) as 'Conversations',\n SUM(overage_credits_used) as
'Overage Credits',\n CASE WHEN MAX(CAST(overage_enabled AS UNSIGNED)) = 1 THEN
'Yes' ELSE 'No' END as 'Overage',\n MIN(date) as 'First Activity',\n
MAX(date) as 'Last Activity'\nFROM lake._tool_q_de [...]
+ "rawSql": "SELECT\n COALESCE(MAX(display_name), user_id) as
'User',\n subscription_tier as 'Tier',\n client_type as 'Client',\n
SUM(credits_used) as 'Credits Used',\n SUM(total_messages) as 'Messages',\n
SUM(chat_conversations) as 'Conversations',\n SUM(overage_credits_used) as
'Overage Credits',\n CASE WHEN MAX(CAST(overage_enabled AS UNSIGNED)) = 1 THEN
'Yes' ELSE 'No' END as 'Overage',\n MIN(date) as 'First Activity',\n
MAX(date) as 'Last Activity'\nFROM lake._tool [...]
"refId": "A"
}
],
