Save that question and turn it into a model.So don’t pre-filter or pre-summarize the data (aside from filtering out rows and columns you wish to exclude from the “view”). Write a question in SQL that brings together the starting data you need, like you’re creating a view for people to query.But you can still get the Action Menu if you: If you write a question using SQL, you won’t get drill-through out of the box. The query builder makes it straightforward to ask the vast majority of analytical questions, and for trickier queries, you have the more surgical custom expressions. You can convert a question composed in the Notebook Editor to a SQL question at any time.īut you probably won’t need to reach for SQL. And there’s no lock-in here you can always convert a query-builder question to SQL. You get the Action Menu on charts automatically when you create a question using the query builder. Add the SQL question to a dashboard and set a custom destinationĬreate a question using the query builder.Use SQL to create a model, then use the query builder.Create the question using the Metabase’s query builder.
METABASE DRILL DOWN HOW TO
How to create charts you can drill through We’ll cover how to set up drill-through on your charts (sometimes called drill-down), and the different ways you can drill through those charts. Or maybe you’ve clicked around on a dashboard and noticed that you can drill down through some charts, but not others. If you’ve only ever written questions in SQL, you may have missed the fact that Metabase could even make your charts explorable. Zooming in on a particular category and timeframe, then viewing the orders that make up one of the bars on the chart. You can create charts that people can drill through in Metabase.
Add the question to a dashboard and set a custom destination.Create a question using the query builder.How to create charts you can drill through.
0 kommentar(er)
