Heatmap question

Hi,
I’m on Grafana version 11.5.9.
I’m trying to build a heatmap and not getting results that I’m looking for.

My data looks like this:

Date                   Amount bin    # of Transactions
02/21/2026 00:00:00           500                 3000
02/21/2026 00:00:00          1000                 2000
02/21/2026 00:00:00          2000                  500
02/22/2026 00:00:00           500                 2500
02/22/2026 00:00:00          1000                 3000

I want to create a heatmap viz on this data. I want time on the x axis, the Amount bins on the Y axis and the cell colored by the number in the # of Transactions column i.e. the color rendered would reflect the Number of Transactions

These are the setting I tried :

Calculate from Data : No

Y Bucket - Size

Left all the Y-Axis configs blank

Whats happening is, its treating Amount bin as a series and plotting both Amount Bin and # of Transactions as values giving me 2 maps one above the other with only a thin single line as a mark on the viz.

Read the doc, checked out YT videos, everythings talking about just time on X axis and a value column which gets binned. Not seeing anything where the binning is defined in a separate column. Any ideas ?

TIA !!