Skip to content
BENIBIX Learn

Drill-Down

Data📊 Analytics & BIBusiness Intelligence (BI)

Also known as Drill Down, Drilldown

Click a total to see the parts under it. Each click goes one level down.

Think of it like

It is like zooming in on a map. First the country, then the city, then your street.

Example

Lucy sees that sales fell in Q3. She clicks Q3 and sees that only September dropped. One more click shows the week.

Why it matters

A total hides where a change came from. Drill-down finds the one part that moved, in a few clicks.

Definition

Drill-down is moving from a total to the details under it. You click a number or a bar to open the next level. A year opens into quarters, then months, then days. Each step shows where the total came from. Going back up a level is called drilling up.
Each click splits the bar into the parts it is made of, until the low month shows.

Common mistake

Building a chart with no levels below it. Then every follow-up question goes back to the data team.

Key takeaways

  1. 1
    Total to detail. Each click opens a finer level.
  2. 2
    Same numbers. The parts always add up to the total.
  3. 3
    Needs levels. Year to month, or country to store.