Need a customize scale for showing colors & labels in Heat Map

Hi Team,
We're exploring the possibilities for using ELK for one of our requirement. We need the heat map visualization as part of our Dashboard.

Currently in HeatMap, Labels are displayed based on Data Aggregation and Colours are paletted based on the Aggregation metrics.

In the above example, Colors are displayed based on Record count, we need the color scale based on the Date values displayed in X-Axis.
Our requirement is Past Dated Blocks should be in RED, Current Date should be in AMBER & Future dates should be in GREEN.

Is there any way to achieve the same in current Heat Map Visualization?
Need your expert technical advise on this regard and your prompt reply is much appreciated :slightly_smiling_face:

Thanks ,
Sunder Rajan R

Hello,
Currently the heatmap colors can only be based on the data value.