topic Re: Conditional Formatting with Cards to Make a Heatmap in Custom Visuals Development Discussion

Conditional Formatting with Cards to Make a Heatmap

NCW — Fri, 17 Nov 2023 16:51:33 GMT

I have a physical seating chart of computers and I am logging the seats that are used the most. I have come up short of standard heatmaps and other map visuals. So, I created the layout with Cards and I applied a conditional format to them on the number of hours they were used. Shown below on the left is the layout with formatting applied and on the right is the table of values also with conditional formatting.

The problem I am having is that when applying conditional formatting to the cards, I am forced to enter a static value for High/Med/Low unlike the table of values. Is there a way to make the cards have a dynamic formatting as the numbers increase?

(Formatting)

Thanks!

Re: Conditional Formatting with Cards to Make a Heatmap

lbendlin — Mon, 20 Nov 2023 00:04:20 GMT

So, I created the layout with Cards

You get extra points for creativity. But maybe you want to consider proper Choropleth map visuals instead.

Re: Conditional Formatting with Cards to Make a Heatmap

NCW — Mon, 20 Nov 2023 14:15:09 GMT

Do you know of a way I can create a custom map and implement it with my layout and data?

Re: Conditional Formatting with Cards to Make a Heatmap

lbendlin — Mon, 20 Nov 2023 17:24:00 GMT

Use your preferred Choropleth map creation tool. Then use a visual like Deneb to show it.

Choropleth of Unemployment Rate per County | Vega-Lite

Re: Conditional Formatting with Cards to Make a Heatmap

NCW — Tue, 28 Nov 2023 20:03:58 GMT

I ended up using the Synoptic Panel visual and a custom floorplan that I quickly made.