最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Grafana date field type lost, how to fix? - Stack Overflow

programmeradmin2浏览0评论

I have a mysql table that looks like:

id, int snapshot_date, datetime filter_id, int issue_count, int

When I run this query in grafana, everything checks out.

SELECT
snapshot_date,
filter_id,
issue_count AS 'value'

FROM tblJiraFilterSnapshots AS a
LEFT JOIN tblFilterIds AS b ON b.id = a.filter_id

Specifically, snapshot date comes into the table formatted as "2025-02-06 07:09:26"

However, when I add the transform

The snapshot_date now shows as

Why is the datetime formatting lost and how can I fix it?

I know I could change the query, but I'm trying to understand the transformations better.

I expect the table to be grouped by snapshot_date as a datetime.

发布评论

评论列表(0)

  1. 暂无评论