Re: List of most popular item
Accepted Solutions
Welcome to the community, @Jared_Miller! :grinning_face_with_big_eyes: What you’re looking to do can be achieved fairly easily using the Chart block. Before setting up the block, though, you would need to do a little setup in your base.
First make a formula field in your order table that builds a unique descriptor for each ordered basket, combining the wood, style, inlay, etc. Just be aware that the more detailed this descriptor becomes, the more data you’re going to end up with in your chart.
Next make a view that uses a filter to limit the orders shown to a given time frame: calendar year, month, etc. Whatever makes sense for the level of reporting you want.
Now make a new Chart block. Pick the view you created, choose the descriptor formula field for the X axis, and set the Order control to Y Value, Descending. You should get something like this (the names across the bottom have been truncated for privacy):
You can mouse over the bars to see the exact number for each item. Unfortunately there isn’t a way to limit this chart to show just the top N items, which is one of the reasons I suggested keeping your formula-built descriptors from getting too specific. The more specific they are, the more bars you’ll have in your chart. However, you could build other views that narrow things down; e.g. a view that only shows things made from walnut, one that only shows a certain type of basket, etc.
The formula needs to concatenate data from other fields that describe the item. For example, say you have a {Wood} field and a {Basket Type} field. Both are single select, and contain a number of different options:
- Walnut, cherry, oak, etc. in the
{Wood}field - Napkin, condiment, centerpiece, etc. in the
{Basket Type}field
Your formula would then look something like this:
Wood & " " & {Basket Type}
Creating output like this:
Maybe? :slightly_smiling_face: I’m trying to wrap my head around some possible ways to pull that off. There are tricks you can do with Airtable involving linking records between tables that might help. Let me work on that a bit and get back to you.
