Skip to main content

What is Cross Dashboard Drill Down?

Regular drill-down only affects the single metric you click on. Cross Dashboard Drill Down takes it further — when you click a data point, the selected dimension value is applied as a filter across all other metrics on the same dashboard. For example, if you click “West” on a revenue-by-region bar chart, every other metric on the dashboard (customer count, order trends, product breakdown) automatically filters to show only data for the “West” region. This is useful for:
  • Multi-metric correlation analysis — see how a dimension selection impacts all KPIs simultaneously
  • Interactive executive dashboards — let stakeholders click once and see the full picture
  • Customer-facing dashboards — provide self-service exploration without building separate filtered views

How It Works

When Cross Dashboard Drill Down is enabled on a metric:
  1. You click a data point (e.g., a bar segment for “West”)
  2. The system extracts the drilled dimension and its value (e.g., region = 'West')
  3. This value is applied as a row-level security (RLS) filter condition to all other metrics on the dashboard
  4. All metrics re-query their data with the additional filter applied
  5. The entire dashboard updates to reflect the selected dimension value
Cross-dashboard drill-down filters work alongside existing dashboard filters. Both are applied simultaneously — the drill filter does not replace your dashboard filters, it adds to them.

Setting Up Cross Dashboard Drill Down

1. Activate Cross Dashboard Drill Down

On the metric page, click the “Settings” icon, navigate to the “Actions” tab, and enable the “Drill down” toggle. Then activate “Cross Dashboard Drill Down” beneath it.
Settings panel showing how to activate cross dashboard drill down

2. View Changes in the Dashboard

Click on a segment of the chart where drill down is enabled. All other metrics on the dashboard will update to reflect the selected value.
GIF demonstrating cross dashboard drill down interaction on chart

3. Clear the Cross-Dashboard Filter

Click on the same dimension in the drilled-down chart to revert all changes and remove the cross-dashboard filter.
Chart image showing how to disable drill down and revert view

Which Metrics Are Affected?

When you trigger a cross-dashboard drill, the filter is applied to all metrics on the same dashboard. The drilled value is passed as an additional filter condition to every metric’s query.
  • Metrics whose underlying data includes the drilled column will filter their results accordingly.
  • Metrics whose queries do not reference that column may show no change or may return an error depending on the SQL generated. For best results, ensure metrics on the same dashboard share common dimensions when using cross-dashboard drill.
  • The filter uses the column name from the drilled metric, so consistent naming across metrics improves reliability.

Cross Dashboard vs. Regular Drill Down

BehaviorRegular Drill DownCross Dashboard Drill Down
ScopeSingle metric onlyEntire dashboard
Other metricsUnaffectedFiltered by drilled value
Use caseDeep-dive into one metricCorrelated analysis across metrics
ClearingBreadcrumb navigationClick the drilled dimension again
Can be combinedYes — enable bothYes — cross-dashboard adds to regular drill
You can enable both regular drill-down and cross-dashboard drill-down on the same metric. The cross-dashboard filter applies to other metrics while the originating metric drills into its own hierarchy.

Troubleshooting

Cause: Cross Dashboard Drill Down is not enabled, or other metrics don’t share the drilled column.Fix:
  • Verify Cross Dashboard Drill Down is enabled in the originating metric’s Settings > Actions tab.
  • Check that other metrics on the dashboard have the same dimension column (by name or alias) as the drilled value.
Cause: Both dashboard filters and the cross-dashboard drill filter are applied simultaneously.Fix:
  • This is expected behavior — both filters are additive. If the dashboard filter already restricts to a different value, the combined filter may return no data.
  • Clear either the dashboard filter or the cross-dashboard drill to see results.
Fix: Click on the same dimension value in the originating chart (the one where you first drilled) to clear the cross-dashboard filter and restore all metrics.
You’ve successfully enabled Cross Dashboard Drill Down. Your dashboard now responds dynamically to drilled dimensions, giving users deeper, interconnected analysis across views.