I have values like
Country | Value |
| 0.17 |
DNK | 3.53 |
ITA | 1.16 |
DEU | 0.73 |
MEX | 0.73 |
JPN_ROW | 0.54 |
SWE | 0.52 |
NLD | 0.48 |
FRA | 0.39 |
KOR_ROW | 0.33 |
KOR | 0.29 |
JPN | 0.28 |
FIN | 0.25 |
AUS | 0.24 |
MYS | 0.22 |
SGP | 0.20 |
GBR | 0.20 |
CAN | 0.20 |
Using the colormix wizard with Sum(TotalConvValue), default normalised upper and lower limits produces a very uniform color block chart except for 1 patch since the DNK value skews the whole table.
If I set the upper and lower limits manually with Fractile(Aggr(Sum(TotalConvValue),Feeder),0.9), Fractile(Aggr(Sum(TotalConvValue),Feeder),0.1), the chart throws an allocated memory exceeded error.
How do I overcome this for a nicely distinguished heat map on the block chart?