Skip to content

::TREEMAP

Dashboards: browser · CLI · servers Community extension: anofox_render

Part-to-whole tiles, area by the measure: ::XAXIS names a tile (its key; a ::LABEL then shows a name instead), ::CATEGORY nests tiles in groups.

Also spelled: ::TREE_MAP

The minimal panel below, rendered

One row per tile: ::XAXIS is its key, the measure its area; ::CATEGORY nests tiles in groups, ::LABEL shows a name instead of the key.

SELECT product ::XAXIS, family ::CATEGORY, revenue ::TREEMAP
FROM (VALUES ('Tea','Drinks',40),('Coffee','Drinks',70),('Juice','Drinks',25),('Bread','Bakery',50),('Cake','Bakery',30)) t(product, family, revenue);

Edit it in the builder ↗

From Which chart fits which question? — open it in the builder ↗:

SELECT 6::COL; SELECT channel::XAXIS, region::CATEGORY, revenue::TREEMAP, 'Revenue by region and channel (::TREEMAP)'::TITLE
FROM (VALUES ('North','Web',420), ('North','Shop',260), ('North','Partner',90), ('South','Web',310), ('South','Shop',180), ('West','Web',150), ('West','Partner',70)) v(region, channel, revenue)

Also in: Which region, country and city bring the revenue? · Where does our revenue come from, from country down to district?

::PIE · ::DONUTCHART · ::GAUGE · ::RADAR · ::SANKEY