Dynamic Heatmap with Retool Table

I wrote this quick guide, accompanied by a YouTube video AND the [json file](Heatmap Table (2).json (51.1 KB)) (disclaimer: all names of companies are generic so no data has been shared) you can upload to see in your retool account.

Steps are simple:

SQL query with your data

Transform data to put Months as columns

Get Minimums and Maximums from each column

Create a Global Function to define the color of the column, using HUE logic

BONUS: Allow users to pick the color they prefer and integrate this into the function

Here's the video tutorial as well: