3/18/2024 0 Comments Metabase docWe call this functionality cross-filtering. When a user clicks on, say, a bar in a bar chart, you could send the value of the clicked bar to the filter, and update cards across the dashboard. If your dashboard contains at least one filter, you can set things up so that clicking on a chart in the dashboard will update a filter. To learn more, check out Custom destinations: choose what happens when people click on charts in your dashboard. Now when we click our chart, we’ll be taken to the URL that we entered above, with the value of the clicked bar inserted into the URL. Next we’ll click Done, then Save our dashboard. Click on the dropdown menu Values you can reference to see your options for which variables you can include in the URL. Your URL can use as many column variables as you want - you can even refer to the same column multiple times in different parts of the URL. So if a user clicks on the Widget bar in our chart, the value of the Category column for that bar ( Widget) would be inserted into our URL. What we’re doing here is referring to the Category that the user clicked on. For example, if you had a column that listed categories, you could change the text in the cell to read: “Click for details about bit. You can also modify the contents of the cells in a given column, replacing the value with custom text. When displaying questions as tables, you can select different click behaviors for different columns in the table. Those user attributes will show up as options when you click on one of the destination’s filters (provided the values are compatible with that filter). In some plans, you can pass a user attribute provided by SSO to the destination, too. You can also send the currently selected value of a dashboard filter on the current dashboard to the destination. In the example above, when a user clicks on the Orders by product category card, Metabase will pass the clicked Product -> Category to the destination dashboard (“Interactive Dashboard”), which will then filter its cards by that Category. Once you select the column that contains the value you want to pass, the sidebar will display the column used to pass the value, as well as the target filter at the destination that Metabase will pass the value to: If you’re linking to a dashboard or a SQL question that has filters, you can pass values from the current dashboard to filters in the destination.įor example, if you link to a dashboard that has a filter for Category, you can pass a value for Category from the origin question to the destination dashboard: External URLs will open in a new tab or window. Internal Metabase destinations (dashboards or saved questions) will load in the same browser tab or window. You can set custom destinations for all questions, including SQL questions. Open the drill-through menuįor questions composed using the query builder, the default click behavior is to open the drill-through menu, which presents people with the option to drill through the data: If your dashboard has a filter, you’ll also see an option to update the filter. SQL questions will only have the option to Go to a custom destination, and Update a dashboard filter, as the drill-through menu is only available to questions composed with the query builder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |