Built with Retool
Dynamic Heatmap with Retool Table
Miguel Ortiz
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:
Like this project
Posted Apr 25, 2025
Create a dynamic heatmap in a retool table. This structures the data in a pivot-like way, and uses global functions to add heat map based on amounts.
Likes
0
Views
12
