Bubble

Bubble charts show the relationship between three numerical variables

Auto Bubble

Auto Bubble

A bubble chart is a scatter chart but with different sized data points. When 3 numeric columns exist a bubble chart will be automatically created.

-- @title: Auto Bubble
-- @subtitle: Auto generted bubble chart
SELECT 
  Profit,
  Amount,
  (CAST(Profit AS FLOAT) / Amount) * 500 as Margin
FROM Sales
WHERE Status = 'Won'
LIMIT 10;

PROFIT	AMOUNT	MARGIN
27064.0	84572.0	160.005675637327
45307.0	133253.0	170.003677215522
14746.0	73728.0	100.002712673611
21198.0	75705.0	140.003962750149
37394.0	196808.0	95.001219462623
15454.0	67191.0	115.000520903097
13263.0	78013.0	85.005063258688
11532.0	76878.0	75.00195114337
13092.0	72732.0	90.001649892757