If the count in each step doesn’t naturally decrease, you may need to sort the steps manually to preserve the actual progression of steps. Keeping the steps sorted with a custom column The advantage of a funnel chart (beyond the visual metaphor) is that Metabase will also show the percentage of the measure that made it through each step. Notice that in the Settings -> Display tab, you can change the Funnel type to “Bar chart”, which is another valid way of representing the data. A (rather chubby) funnel chart that uses categories as steps in the funnel. In the settings of a funnel chart, under the Data tab, you can set the Step (in this case we’re using the product category) and the Measure (the count of orders). To get a funnel chart, we clicked on Visualization in the bottom left, and selected Funnel. Then we’ve sorted the results by count, descending. What we’ve done is joined the Orders and Products tables (see Joins in Metabase), summarized the count of orders, and grouped those counts by product category. The notebook view of the query for our funnel chart.
Here’s the notebook view of our query: Fig.
We’re going to pretend that the steps in our funnel are product categories (because we don’t have anything like statuses or pages or other progressions in our Sample Database). Funnel chart example using the query builder So we’ll have to get a little creative here to come up with examples for funnel charts. The Sample Database doesn’t contain events it’s just four tables with order, product, and customer information. We’ll show examples both in the query builder and the sql editor:
#METABASE FUNNEL HOW TO#
We’ll walk through how to build a funnel chart in Metabase using the Sample Database included with your installation so you can follow along. Then how many people viewed a product page (step 2), how many added that item to their cart (step 3), and so on. The first step (or gate) would be how many people visited your site. Typically they’re used to show how many people make it through a particular sequence, such as a checkout flow on a website.
#METABASE FUNNEL SERIES#
One of the funnel charts we'll build with the Sample Database.įunnel charts visualize how a measure breaks out across a series of steps. Keeping the steps sorted with a custom columnįig.Funnel chart example using the query builder.We cleaned up the data reference sidebar in the native editor, and made it easier to search for models and questions to reference in your SQL questions.Native editor and data reference upgrades datetimeAdd and datetimeSubtract functions so you can "math" dates.second, minute, hour, day, week, month, quarter, year functions for extracting bits of a timestamp.We added a bunch of new functions for dealing with dates in the query builder: New datetime functions for custom expressions Models are easier to reference in SQL questions.When joining against a persisted model in a native query, Metabase will, if possible, use the model's cached results to return results faster. You’ll get faster results for SQL questions built on top of persisted models.Models retain their metadata, even when you change the model’s underlying query.You can create a model from the + New menu (as well as from an existing saved question).Models in Metabase had a bit of a rough landing, but since they're such a fundamental building block for a healthy data culture, we did a ton of work to make models easier and more reliable to work with. Pie charts can now show labels inside the pie.Which is a pretty big deal, especially if you want to do things like change up the order of steps in a funnel chart. We gave them the same feature set as bar charts, rotated 90 degrees, which was actually harder to pull off than you might think. Labels are above the charts, and they're laid out in rows. Line, area, bar, and combo charts now have better legends.
#METABASE FUNNEL PLUS#
Plus now you can get gauge charts via email and Slack.
0 kommentar(er)
