::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 data it needs
Section titled “The data it needs”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 ::TREEMAPFROM (VALUES ('Tea','Drinks',40),('Coffee','Drinks',70),('Juice','Drinks',25),('Bread','Bakery',50),('Cake','Bakery',30)) t(product, family, revenue);In an example
Section titled “In an example”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)'::TITLEFROM (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?
Related
Section titled “Related”::PIE · ::DONUTCHART · ::GAUGE · ::RADAR · ::SANKEY