How to use Metabase to build an internal lookup tool to quickly find details about your customers, orders, or other data.
Build a record lookup tool with Metabase. How to add filter widgets to dashboards and connect them to Field Filter variables in multiple SQL questions. Adding filters to dashboards with SQL questions. With just a few clicks, you can configure any chart or table to update a dashboard filter. Cross-filtering: using a chart to update a dashboard filter. You can set up dashboard cards to send people to dashboards, saved questions, and URLs, and use values from the card to update filters at the destination, or parameterize links to external sites. Custom destinations: choose what happens when people click on charts in your dashboard. Link filters in dashboards to limit the choices available in one filter based on the current selection of another filter. Learn how to make great business intelligence dashboards. Learn how to use SQL to calculate customer lifetime value in Metabase. How to calculate customer lifetime value (LTV) with SQL. Learn everything you need to know about using different SQL join types.Ī simple trick to preserve the order you want the bars to appear in a chart. 
How to combine information from two tables with a join. Learn about the Metabase features you can use to keep your SQL code organized. They allow you to reuse results in the same query, and perform multi-level aggregations. Simplify complex queries with Common Table Expressions (CTEs)ĬTEs are named sets of results that help keep your code organized.Learn everything you need to know about using snippets in SQL code. Use SQL to group results by a time period, compare week-over-week totals, and find the duration between two dates. Learn how to use Metabase Field Filters in SQL queries to build filter widgets. Field Filters: create smart filter widgets for SQL questions.How to create filter widgets in native SQL queries using basic input variables for text, numbers, and dates. Create filter widgets for charts using SQL variables.
SQL best practices: a brief guide to writing better SQL queries.
0 kommentar(er)
