Start from one total and drill into any dimension. The next total is exactly the row you left — nothing lost, nothing counted twice.
| Product Group | # Transactions |
|---|---|
| All | 8,361 |
| 3,425 | |
| 3,276 | |
| 1,660 |
Sample data only — runs in your browser, never hits a database.
Want this on your own data?
Sign inClick a value, pick a dimension, repeat. Breadcrumbs let you jump back up the chain.
Every drill is a decomposition of one number. The new Total always matches the row you selected.
Views are config, not a drag-and-drop builder. ClickHouse answers each aggregate in milliseconds.