Unable to plot multiple series with 1 query (MySQL, Timeseries)

Environment
MariaDB 10.6
Grafana 9.3.1

I am not seeing this issue in my Grafana 7.3.7 environment

Sample Data (Grafana Table)
time | metric | value

2021-12-09 18:00:00 | push | 24
2021-12-09 18:00:00 | pull | 6
2021-12-09 18:00:00 | delete | 17
2021-12-12 18:00:00 | push | 3
2021-12-12 18:00:00 | pull | 1
2021-12-20 18:00:00 | delete | 53
2021-12-20 18:00:00 | push | 7

My Query

SELECT DATE(created_at) as time , action as metric, count(*) as value
FROM gitlab_metrics_dev.events 
WHERE author_id IN ($author_id) AND   $__timeFilter(created_at) 
GROUP BY action, DATE(created_at)
ORDER BY created_at ASC

Added a brand new Timeseries panel and pasted in the above query, and am only seeing 1 series appear in my timeseries line chart. I am expecting to see 3 series (pull, push, delete)

I’ve spent hours troubleshooting and searching online and am stuck. Any help would be appreciated!

Maybe try Transformation tab and choose data frames?