Could the new Heatmap work like Carpet Plot

I use Carpet Plot to show a dot for each hour (y-axis) of each day from a year (x-axis).

My data is stored in an influxDB:

How could i do this with heatmap in grafana 9?

Could you please provide some sample data as csv inline like

time,value
2022-06-18 01:00:00,4

Created with random data

sry for late reply

carpet plot changes x with y, so you could have a different view

public access: Grafana