I was pleased with the outcome of trying to generate a heat map, see below. However, I was stuck with this item: Q. Is it possible to apply a filter to hide empty columns? It seems possible to filter rows but not obvious for columns. In this example there are only 5 patient types. It would be nice …

Here is a custom Heat Map I created, please feel free to try it. It uses dates for the heat map, but even if it doesn’t fit your needs, maybe it could spark some ideas. [image] fire Color Your Calendar: Custom Heat Map with 3 Stunning Accent Colors! datesparkles Project Showcase …

TBH I stopped the video as soon as you mentioned Java and then CSS… I prefer no code solutions and am not willing to go down that rabbit hole… but thank you for responding and your output does look cool. Nice job.

Hi @Simon_Hill ! Well… here is an idea, without JavaScript nor CSS. Also gonna be honest: it works, it’s dynamic, it was fun to think about how to help you on this one. The rest is up to you (especially the “should I really do that” part :smiley: ) The result [The final result] The starting poi…

[image] Nicolas_Joseph: Create a Data Grid. Add as many columns as the maximum you can have. I fear there is a misunderstanding about the request. I have successfully created the heat map component and it is working perfectly well. It dynamically adjusts to the data and displays cells in 10 …

What I understood - going back to your first screenshot - is that you only want to display the columns Patient 1, Patient 2, Patient 3, Patient 4 and Patient 5. As for Patient 6 and following columns, they are empty, so you want them to be hidden. That was the assumption I made in my answer, and I…

Nope, I still don’t see how you are solving for the question. Focus on the Data Grid Component. You still have to stipulate how many columns (data series) are required. That is a manual step. It is not possible to hide a data series even when the data is empty. [image] [image] In the meantime I…

I think that was the point of the solution provided by @Nicolas_Joseph . He used multiple data grids as well, but I believe his solution does in fact account for column gaps.

But even if you have column gaps that are accounted for the solution proposed still does not hide empty columns in the Grid component. You still have to manually specify the number of columns. There is no way to dynamically control visibility (remember each column will have a title even if the data …

Using a Data Grid component to simulate a Heat Map

Ask for Help

Eric_Penn June 27, 2025, 4:18pm 2

Here is a custom Heat Map I created, please feel free to try it. It uses dates for the heat map, but even if it doesn’t fit your needs, maybe it could spark some ideas.

Topic		Replies	Views
Visibility conditions on Table & Data Grid columns Feature Requests	5	138	June 5, 2025
Hide Column Names of Tables & Data Grids Without Data Feature Requests	4	112	August 18, 2024
Visibility Conditions for Table & Grid Columns Feature Requests	1	78	June 19, 2024
No show empty column in Table Collection component Ask for Help	4	41	March 16, 2025
🦾 Data Grid Component in Glide Pages! Community Resources	58	5961	November 18, 2023

Using a Data Grid component to simulate a Heat Map

Related topics