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