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.