Help

Re: Creating Total count field from Multiple Select Fields

173 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ljanuary
4 - Data Explorer
4 - Data Explorer

Hello! 

I am new to creating formulas in Airtable, and therefore need help creating a total count field based on multiple selections. What I want to have is the top items ordered (maybe top 15 items) and show which employees have ordered that item. I've created an Interface but it currently shows ALL the items and I haven't figured out a way to display only the highest totals of items. Also, I need to have a filter where when the item has the majority of the same words, it combines those two items together as one item (we did a "sale" so some items have a "25% off" in front of the item name). 

Snag_1f48e20c.png

Snag_1f493d5b.png

Snag_1f4a6aa0.png

 Please help! 

1 Reply 1
DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

In your "Swag" table, add a count field that tallies the number of linked records (or rollup field if it's something more complex than pure record number), then you can lookup that field in the table that's feeding your interface. In your interface you can add a simple filter to only display records occurring more than once or twice, and then sort your x-axis by descending, which will clean up that graph a lot. 

On the 25% off, that's tougher. Maybe there's a script out there somebody has, but I'd say you don't track information in that manner. They ordered the same item, it should be named the same, with the 25% expressed in either a separate transactions table, or perhaps some kind of sale select field which impacts the calculation of your total due.