Counting tags and classifying them according to their recurrence

Topic Labels: Formulas
313 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi everyone! I need your help with a problem I still haven't managed to solve on Airtable 

I'm creating an online store where the cart is generated by answering a diagnostic/questionnaire.
Each answer to the questions assigns tags (words from the "single select" menu) to the people who answer.
Some tags may appear several times.

I want to create a program that allows me to count the number of times a tag appears in one cell and rank them from the one that appears the most to the one that appears the least.
Then I would like to be able to search, in the "product" table, those that correspond the most to the first 5 tags of the ranking.
Thus, I will give the best product to the people answering the questionnaire.
(If you also know how to use the TF-IDF (Term Frequency - Inverse Document Frequency) in my case, it would help me a lot)

I thank in advance the people who will want to help me with this original request 🙏

0 Replies 0