I am trying to visualize some data of an index using a heatmap.
On X axis, I have values of a variable called A.
On Y axis, I have values of a variable called B.
I am planning to use the “COUNT” metric in order to visualize how many times A intersect with several values of B.
For example, If I have A=10 and B is between 1 and 5 => it should be considered as one square in the heatmap.
For the moment, if I take the example above, the heatmap show the intersection between a value of A (in this case 10) and a value of B (for example 1). So I don’t know how to configure the dashboard to apply my logic.
Does someone know if it is possible to do it?
Thank you in advance for the help and hope I was clear enough in my explanation.