Discover · metabase.com

Making pivot tables faster with GROUPING SETS

Metabase metabase.com

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 this QR code to open the same public page

Scan to open this page. Your saved notes and account access are not included.

Download QR code

Open the page link

In the piece

Named in it

Keep going

Each of these is read from what this estate already kept: the feed a piece came through, the publisher behind it, the credits and topics the publisher printed. None of it is a recommendation, an identity or a record kept anywhere else.

Also from Metabase

  1. Rebuilding the Metabase MCP server: lessons for MCP tool designmetabase.com
  2. From Toronto Hackathon to Stockholm meetup: Metabase data app world tourmetabase.com
  3. 'Wait, you don't have a semantic layer yet?' AI analytics readiness pulsemetabase.com
  4. As humans write less code: workloads shift from human to agent verification with iterative test suitesmetabase.com
  5. We don't use PHPmetabase.com
  6. The bottleneck moved: how to build a semantic layer for AI Analyticsmetabase.com