Heatmap

Heatmaps show the strength of a value compared to others across two dimensions

Auto Heatmap

Auto Heatmap

When 2 string columns and 1 numeric column exists

-- @title: Auto Heatmap
-- @subtitle: An example auto generated heatmap comparing two categories
SELECT
Owner,
Channel,
count(*) as Sales
FROM Sales
WHERE Sales.Status = 'Won'
GROUP BY Owner, Channel

An example auto generated heatmap chart

OWNER	CHANNEL	SALES
Earl	search	2.0
Bernard	coldcall	5.0
Oliver	event	3.0
Oliver	coldcall	1.0
Carrie	search	9.0
Norbit	referral	3.0
Norbit	event	5.0
Norbit	search	2.0
Bernard	referral	25.0
Artie	referral	50.0
Devon	referral	12.0
Max	event	4.0
Norbit	pr_ad	1.0
Carrie	pr_ad	3.0
Norbit	coldcall	1.0
Bernard	search	7.0