
Making pivot tables faster with GROUPING SETS
Metabase metabase.com
Listen to this summary
We got tired of waiting for pivot tables to load, so we made them faster.
Previously, pivot tables in Metabase could be slow and the implementation needed complicated logic to keep results consistent. Metabase would send separate queries to the database to calculate row, column, and grand totals. That meant a pivot with two grouping fields could run four queries, one with five fields could run up to 32.
More ways to use this
Open on another device
Scan to open this page. Your saved notes and account access are not included.