This is an automated email from the ASF dual-hosted git repository.
klesh pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 74487a75c fix(grafana): use IS TRUE for boolean comparisons in Copilot
adoption dashboard (#9126) (#9133)
74487a75c is described below
commit 74487a75c18703bdebeb3bcfd58f8865442eec16
Author: Keerthan Poojary <[email protected]>
AuthorDate: Wed Sep 16 17:59:39 2026 +0530
fix(grafana): use IS TRUE for boolean comparisons in Copilot adoption
dashboard (#9126) (#9133)
---
grafana/dashboards/mysql/github-copilot-adoption.json | 2 +-
grafana/dashboards/postgresql/github-copilot-adoption.json | 6 +++---
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/grafana/dashboards/mysql/github-copilot-adoption.json
b/grafana/dashboards/mysql/github-copilot-adoption.json
index e018b6ede..f6637024c 100644
--- a/grafana/dashboards/mysql/github-copilot-adoption.json
+++ b/grafana/dashboards/mysql/github-copilot-adoption.json
@@ -1 +1 @@
-{"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0,
211, 255, 1)","name":"Annotations &
Alerts","type":"dashboard"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"links":[],"liveNow":false,"panels":[{"datasource":"mysql","description":"Latest
daily active users
count","fieldConfig":{"defaults":{"mappings":[],"thresholds":{"mode":"absolute","steps":[{"color":"green","value":null},{"color":"yel
[...]
\ No newline at end of file
+{"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0,
211, 255, 1)","name":"Annotations &
Alerts","type":"dashboard"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"links":[],"liveNow":false,"panels":[{"datasource":"mysql","description":"Latest
daily active users
count","fieldConfig":{"defaults":{"mappings":[],"thresholds":{"mode":"absolute","steps":[{"color":"green","value":null},{"color":"yel
[...]
\ No newline at end of file
diff --git a/grafana/dashboards/postgresql/github-copilot-adoption.json
b/grafana/dashboards/postgresql/github-copilot-adoption.json
index 7a4eee270..45e896fa0 100644
--- a/grafana/dashboards/postgresql/github-copilot-adoption.json
+++ b/grafana/dashboards/postgresql/github-copilot-adoption.json
@@ -1270,7 +1270,7 @@
"datasource": {"type": "grafana-postgresql-datasource", "uid":
"devlake-postgres-api"},
"format": "table",
"rawQuery": true,
- "rawSql": "SELECT COUNT(DISTINCT user_login) AS \"Agent Users\" FROM
_tool_copilot_user_daily_metrics WHERE $__timeFilter(day) AND
('${connection_id}' = '' OR connection_id::text = '${connection_id}') AND
scope_id = '${scope_id}' AND used_agent = 1",
+ "rawSql": "SELECT COUNT(DISTINCT user_login) AS \"Agent Users\" FROM
_tool_copilot_user_daily_metrics WHERE $__timeFilter(day) AND
('${connection_id}' = '' OR connection_id::text = '${connection_id}') AND
scope_id = '${scope_id}' AND used_agent IS TRUE",
"refId": "A"
}
],
@@ -1324,7 +1324,7 @@
"datasource": {"type": "grafana-postgresql-datasource", "uid":
"devlake-postgres-api"},
"format": "table",
"rawQuery": true,
- "rawSql": "SELECT COUNT(DISTINCT user_login) AS \"Chat Users\" FROM
_tool_copilot_user_daily_metrics WHERE $__timeFilter(day) AND
('${connection_id}' = '' OR connection_id::text = '${connection_id}') AND
scope_id = '${scope_id}' AND used_chat = 1",
+ "rawSql": "SELECT COUNT(DISTINCT user_login) AS \"Chat Users\" FROM
_tool_copilot_user_daily_metrics WHERE $__timeFilter(day) AND
('${connection_id}' = '' OR connection_id::text = '${connection_id}') AND
scope_id = '${scope_id}' AND used_chat IS TRUE",
"refId": "A"
}
],
@@ -1809,7 +1809,7 @@
"datasource": {"type": "grafana-postgresql-datasource", "uid":
"devlake-postgres-api"},
"format": "table",
"rawQuery": true,
- "rawSql": "SELECT day AS time, COUNT(DISTINCT CASE WHEN used_agent =
1 THEN user_login END) AS \"Agent Users\", COUNT(DISTINCT CASE WHEN used_chat =
1 THEN user_login END) AS \"Chat Users\" FROM _tool_copilot_user_daily_metrics
WHERE $__timeFilter(day) AND ('${connection_id}' = '' OR connection_id::text =
'${connection_id}') AND scope_id = '${scope_id}' GROUP BY \"day\" ORDER BY 1
NULLS FIRST",
+ "rawSql": "SELECT day AS time, COUNT(DISTINCT CASE WHEN used_agent
IS TRUE THEN user_login END) AS \"Agent Users\", COUNT(DISTINCT CASE WHEN
used_chat IS TRUE THEN user_login END) AS \"Chat Users\" FROM
_tool_copilot_user_daily_metrics WHERE $__timeFilter(day) AND
('${connection_id}' = '' OR connection_id::text = '${connection_id}') AND
scope_id = '${scope_id}' GROUP BY \"day\" ORDER BY 1 NULLS FIRST",
"refId": "A"
}
],
