I am in the process of creating a heatmap, which displays the results of statistical tests in which I want to include two color arguments. The first argument should link to the significance of the tests. I want the color red for non-sig and green for significant. Consequently, for the significant results, I want to include a color argument in which the higher the value the darker the color.
The issue is that the first part is linked to a dimension whereas the second part to a measure and I somehow can't combine these.
Does anyone know what I should do?
Any workbook may be with fake data?