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 24d50c032 fix(q-dev): cast Hour to string for Active Hours bar chart
x-axis
24d50c032 is described below
commit 24d50c032699580692af46f31b1c730f443f072d
Author: warren <[email protected]>
AuthorDate: Sun Mar 15 15:28:42 2026 +0800
fix(q-dev): cast Hour to string for Active Hours bar chart x-axis
---
grafana/dashboards/qdev_logging.json | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/grafana/dashboards/qdev_logging.json
b/grafana/dashboards/qdev_logging.json
index 59a6556da..462adcd98 100644
--- a/grafana/dashboards/qdev_logging.json
+++ b/grafana/dashboards/qdev_logging.json
@@ -159,7 +159,7 @@
"editorMode": "code",
"format": "table",
"rawQuery": true,
- "rawSql": "SELECT\n hour_of_day as 'Hour',\n SUM(chat_count) as
'Chat Events',\n SUM(completion_count) as 'Completion Events'\nFROM (\n
SELECT HOUR(timestamp) as hour_of_day, COUNT(*) as chat_count, 0 as
completion_count\n FROM lake._tool_q_dev_chat_log\n WHERE
$__timeFilter(timestamp)\n GROUP BY HOUR(timestamp)\n UNION ALL\n SELECT
HOUR(timestamp) as hour_of_day, 0 as chat_count, COUNT(*) as completion_count\n
FROM lake._tool_q_dev_completion_log\n WHERE $__timeFilt [...]
+ "rawSql": "SELECT\n LPAD(CAST(hour_of_day AS CHAR), 2, '0') as
'Hour',\n SUM(chat_count) as 'Chat Events',\n SUM(completion_count) as
'Completion Events'\nFROM (\n SELECT HOUR(timestamp) as hour_of_day, COUNT(*)
as chat_count, 0 as completion_count\n FROM lake._tool_q_dev_chat_log\n WHERE
$__timeFilter(timestamp)\n GROUP BY HOUR(timestamp)\n UNION ALL\n SELECT
HOUR(timestamp) as hour_of_day, 0 as chat_count, COUNT(*) as completion_count\n
FROM lake._tool_q_dev_complet [...]
"refId": "A"
}
],
