Celiq
v0.12Open app โ†—
Docs/Analytics/Drill down

Drill down

Click a data point on a Mosaic tile or Discover result to open a focused breakdown โ€” by dimension, underlying rows, or an Orion explanation.

TracerWeaverLuminaryUpdated June 2026 ยท 6 min read
โœฆ
In this section
Part of Celiq's semantic layer platform. Connect your warehouse, model your data once, query it everywhere.
๐Ÿ’ก
Tip
What it is โ€” An on-click interaction that opens a focused breakdown of a single data point without changing the rest of your dashboard.
When to use it โ€” When one bar, slice, or point looks unusual and you want to split it by another dimension, see the rows behind it, or get an AI explanation.
Where to find it โ€” Click any data point on a tile in a Mosaic, or on a result in Discover (the Drill Anywhere menu).
Who can use it โ€” Luminary, Weaver, and Tracer.

Drill down lets you start from a number that caught your eye and go deeper into it โ€” one click on a chart point opens a small menu of next steps. Each step keeps the focus on the value you clicked, so you can investigate without disturbing the surrounding tiles.

This is different from cross-filtering. Drilling opens a focused breakdown of one value; cross-filtering applies that value as a filter to every tile on the dashboard. Both start from the same click menu โ€” this page covers the drill actions, and Cross-filtering covers the dashboard-wide filter.

Overview

When you click a data point on a Mosaic tile, Celiq does not filter anything implicitly. Instead it opens an inline interaction menu at the click point. The menu lists, in order:

  • Filter dashboard by this value โ€” the cross-filter action (covered on its own page).
  • Drill intoโ€ฆ โ€” a list of dimensions you can break the clicked value down by.
  • View rows โ€” the underlying, filtered records.
  • Explain with Orion โ€” an AI decomposition of the clicked value.

Choosing any of the drill actions opens the Drill modal: a focused panel with a sidebar of drill options on the left and the result on the right. The modal header shows the tile title and the exact context you clicked, for example channel = Organic Search.

When to use it

  • A single bar, point, or slice is much higher or lower than the rest and you want to know which sub-segment drove it.
  • You need to see the actual rows behind an aggregated number before you trust it.
  • You want a fast, plain-language read on what is notable about a value and what to look at next.
  • You are exploring in Discover and want to pivot a result by a related dimension without rebuilding the query.

Reach for Cross-filtering instead when you want the whole dashboard to react to the value you clicked.

Concepts

TermWhat it means
Clicked contextThe field = value pair you clicked, e.g. channel = Organic Search. Every drill action is scoped to it.
Drill dimensionA dimension you break the clicked value down by. The breakdown groups the filtered data by that dimension.
Drill path / drill dimensionsThe list of dimensions offered for drilling. They come from the domain's semantic model and are scoped to the clicked tile's node.
Node scopeDrill options are limited to fields on the same node as the tile, so an orders tile does not show unrelated fields from other nodes.
View rowsThe underlying records behind the clicked value, with no extra grouping.
Drill historyBreadcrumbs in the modal header that track each successive breakdown you opened.
GrainThe time bucket of a tile (day, week, month, quarter, year). It affects how View rows resolves a clicked date.

Getting started

You need access to a Mosaic (or to Discover) and at least Tracer-level permission. Open the dashboard that contains the tile you want to investigate, then click directly on a data point โ€” a bar, a line point, a pie slice, or a table value.

In Discover, run a query so you have results on screen, then use the Drill Anywhere menu on a result value.

Step-by-step

1

Click a data point on a tile

On a Mosaic tile, click the bar, point, or slice you want to investigate. An inline menu opens at the click position. Its top line shows the value you clicked, for example Channel: Organic Search.

2

Pick a drill action

Choose one of:


โ€ข Drill intoโ€ฆ โ†’ By to open a breakdown grouped by that dimension.
โ€ข View rows to see the underlying, filtered records.
โ€ข Explain with Orion to get an AI analysis of the clicked value.
(The first menu item, Filter dashboard by this value, is cross-filtering, not drilling.)

3

Read the breakdown in the Drill modal

The Drill modal opens with the tile title and your clicked context (field = value) in the header. The left sidebar lists every drill dimension plus View rows and Explain (Orion). The selected result shows on the right as a table.

4

Drill again to go deeper

Click another dimension in the sidebar to break the current view down further. Each new breakdown adds a step to the drill history breadcrumbs in the header (for example By region โ€บ By category).

5

Step back or close

Use the โ† Back link in the breadcrumbs to clear the history and return to the menu, or click ร— to close the modal. Closing the modal does not change the dashboard.

If the inline menu offers More dimensions โ†’ (because the tile's node has more drillable fields than fit in the list), choosing it opens the Drill modal directly on its dimension menu so you can pick from the full list.

Examples

You are looking at a Revenue by Channel bar chart and the Organic Search bar is unusually high.

  1. Click the Organic Search bar. The inline menu opens with Channel: Organic Search at the top.
  2. Choose Drill intoโ€ฆ โ†’ By Country. The Drill modal opens a breakdown of Organic Search revenue grouped by country.
  3. India stands out, so click By Device in the sidebar to split it further. The header breadcrumbs now read By country โ€บ By device.
  4. Click View rows to see the underlying orders, or Explain (Orion) for a written read on the value.

Under the hood, the breakdown re-runs the tile's query with the clicked value added as a filter and the chosen dimension as the new grouping. The equivalent query state looks like this:

json
{
  "selected_attributes": [{ "node": "orders", "attribute": "country" }],
  "filters": [
    { "field": "channel", "operator": "=", "value": "Organic Search" }
  ]
}
View rows behaves differently for time-based tiles. If you click a point on a tile with a month grain, the x-axis value is the start of the period (for example 2025-08-01). An exact match on that date would return zero rows, so Celiq expands it to a full-period range automatically:
json
{
  "globalFilters": [
    { "field": "order_date", "operator": ">=", "value": "2025-08-01" },
    { "field": "order_date", "operator": "<=", "value": "2025-08-31" }
  ]
}

The same expansion applies to week, quarter, and year grains.

Drill Anywhere in Discover

In Discover, the Drill Anywhere menu opens on a result value. It lists drill dimensions grouped by node, with a search box at the top so you can filter long lists by label. Each entry shows the dimension label and its node.field reference. A View rows action sits at the bottom of the menu. Selecting a dimension pivots the result by it; selecting View rows shows the records behind the value.

Best practices

  • Drill down, not wide: break one interesting value into sub-segments before you reach for a dashboard-wide cross-filter.
  • Follow a hypothesis. Each breakdown should answer "which part of this drove the change?" โ€” the breadcrumbs keep your trail visible.
  • Use View rows to sanity-check an aggregate before you act on it, especially for surprisingly round or surprisingly extreme numbers.
  • Use Explain (Orion) to get suggested next dimensions when you are not sure where to look โ€” it points at two or three dimensions worth investigating.
  • Keep tiles on a sensible node. Drill options are scoped to the tile's node, so a well-modeled tile gives you the most relevant drill paths.

Tips

๐Ÿ’ก
Tip

The Drill modal is non-destructive โ€” it never changes the dashboard or its filters. Explore freely, then close it to return to your view exactly as it was. To affect every tile instead, use Filter dashboard by this value (Cross-filtering).

Common mistakes

โš ๏ธ
Warning
Confusing drill with cross-filter. The top item, Filter dashboard by this value, changes every tile; the Drill intoโ€ฆ, View rows, and Explain items open a focused breakdown only.
Expecting fields from other nodes. Drill dimensions are scoped to the tile's own node, so you will not see unrelated fields (such as a spend field on an orders tile).
Drilling a tile with no domain. A tile that has no domain linked cannot run a drill query.

Troubleshooting

SymptomCauseFix
Sidebar shows "No other dimensions"The tile's node has no additional drillable dimensions beyond the one you clicked, or the domain's drill dimensions have not loaded.Pick View rows or Explain (Orion) instead, or model more attributes on the node in Forge.
View rows shows "No data"The clicked value has no matching rows, or a raw timestamp was matched exactly on a grain tile.For time tiles the range is expanded automatically; if it still returns nothing, confirm the date field and the clicked period contain data.
Result area shows "Query failed"The breakdown or rows query errored.Re-open the drill, check the tile has a valid domain and reveal, and confirm the warehouse connection is healthy via Data health.
Orion shows "Could not load Orion insight."The Orion insight request failed.Retry Explain (Orion); confirm the workspace has a working AI key and that the tile returns rows.
Inline menu never opens on clickThe click could not resolve a field and value (for example a chart with no dimension configured).Make sure the tile has a dimension/attribute configured so the clicked point maps to a field = value.