16.3 Drill Down vs Expand – the Difference
| Drill down / Go to next level | Expand all down one level | |
|---|---|---|
| Parent level after the action | Hidden (replaced) | Kept and combined with the child |
| Axis labels | Child only ("Kothrud") | Parent + child ("Pune Kothrud") |
| Same child name in two parents | Summed together (e.g. two "Station Road" areas merged) | Kept separate |
| Best for | Focusing on one item (drill mode) or comparing children across parents | Seeing detail while keeping context |
He farak kalla ki drill cha confusion sampla. Aata pudhe jaauya matrix kade.
Ravindra Bagale's Tip
Mitrano, ithe chuk karu naka: using Go to next level on Month across several years adds January 2024 and January 2025 together. Use Expand all down to keep the Year context, or use a Year Month column. Nehmi check the axis labels after drilling. Punha ekda karun bagha, mag pudhe jaa.