Drill-through possibilities

Hi there,

We’ve seen various posts about drill-downs and drill-throughs but my team and I were unable to determine what’s exactly possible within Metabase.

Here’s an example of what we’d like to do:

  • We create a native query question that returns all new customers (and their data) from the database
  • We create a custom question with the GUI that returns the total number of rows from the previous query and displays them as a number
  • The question that displays a number gets placed in a dashboard
  • When the user clicks on this number, these rows get returned together with their respective data

Our question is: Is this possible within Metabase? If so, how?

Thanks in advance.

Hi @quinten
Yes, but two things:
Number (previously Scalar) visualizations currently doesn’t have drill-through capabilities:
https://github.com/metabase/metabase/issues/4983 - upvote by clicking :+1: on the first post
And you would need a Group field (that could be the customer id) for drill-through to work as you expect if you used a Table visualization.

For general drill-through understanding: https://www.metabase.com/blog/drilling-through-data/index.html

Hi @flamber,

Thanks for your reply!

I upvoted the post, let’s hope it gets added soon!
I’ll have a look at the link you sent me asap.
At least I have a starting point now.