Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Show how many duplicates there are in a lookup field and of what duplicate

Topic Labels: Formulas
1324 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Philip_Begel
6 - Interface Innovator
6 - Interface Innovator

Hello wonderful Airtable community! I was wondering if anyone knew a way to take values in a lookup field and then provide the percentage of duplicate values?

(e.g. for numerical values: “5,6,6,6,7” the output would be 20% for 5, 20% for 7, and 60% for 6)
(and e.g. for string values: “Dentist, Doctor, Surgeon, Dentist, Doctor” the output would be 40% for dentist, 40% for doctor, and 20% for Surgeon)

OR a way to see this in a chart if that’s easier

Edit:
figured it out. In the shared view for the base (so that the filter doesnt stay locked), just have to filter in the View I needed, and the chart will update accordingly.

1 Reply 1

You can choose to display the “% unique” from the summary bar.