I am trying to create a heatmap chart with 2 dimensions, customer name and date, and 1 measure: Sum of Amount.
There is a default "Mean in Scale" function used to configure the scale of colours that would change according to the magnitude of Amount.
However, I have multiple customers and some customers may have much larger amounts, and when both companies are displayed the scale is skewed towards the larger amounts.
Is there a way to configure the chart such that each customer dimension, will have its own colour scale, almost like an AGGR function and grouping by customer?
we are offering a Heatmap, that is usually used for Risk Management. The function can fit to you needs and it is available in the Garden Branch for testing. Please have a look at: