Databases Reference
In-Depth Information
8.
We will use the default values in the
Step 3
window (
Enhanced Colors
enabled and
Value Saturation
set to
Use Upper (Lower) Color
), so just click
on
Finish
for the new color expression to be generated. The new expression,
which will be automatically inserted into the
Edit Expression
window,
should look like the following expression:
ColorMix2 (if(rangemin(1,rangemax([Load Factor
%],0.5))<0.75,-Sqrt(-(rangemin(1,rangemax([Load Factor %],0.5))-
0.75)/(0.75-0.5)),Sqrt((rangemin(1,rangemax([Load Factor %],0.5))-
0.75)/(1-0.75))), ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0),
ARGB(255, 0, 0, 160))
This expression uses a combination of different color functions, as well as
nested
If
statements. Even though the expression looks complex, it shouldn't
be a problem for us since it is auto generated by the
Colormix wizard
.
9.
Click on
OK
in the
Edit Expression
window to apply the changes and then
OK
again from the
Chart Properties
window.
The modified heat map should now adopt the following look:
If we compare the new chart to what we had previously, it's evident that the new
look is more dynamic and has additional levels of intensity, thus providing a more
detailed insight.