The widget allows people to enter text to filter records for product titles containing that text.įor now, we’ll just be focusing on filters applied to questions written in SQL. An example question, written in SQL, that uses a basic text variable to power a filter widget. To give people the option to input values on saved SQL questions, we can write SQL queries with variables, and Metabase will automatically create filter widgets that people can use to enter values. Introduction to SQL variables and filter widgetsįor example, using the Sample Database included with Metabase, we might write a question in SQL that pulls product information about our orders, but we want viewers of that question to specify the category of products that they want to view. While Metabase makes it easy to summarize and visualize data without SQL, data analysts sometimes need to dig into complicated queries, which they can write using Metabase’s SQL editor. This article walks through how to create questions in Metabase using native SQL queries so that viewers of our questions can plug in values and filter the results.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |