Search number of a value occurence on any field of a unique list

Hi the Bubble Community,

Do you know a simple way to count how much values appears on fields of a unique list ?

For exemple :

List “sport” (we would like calculate the percentage of sport using “ball”)

Fields = value
football : ball
baseball : ball
basketball : ball
rugby : ball
tennis : ball
hockey : not ball
volleyball : ball
cricket : not ball
soccer : ball
badminton : not ball
golf : ball

How to count the number of value ‘ball’ on this unique list ? We can checkvalue of each field … but I search a more simple way (just 1 expression)

Thank you very much !

This topic was automatically closed after 70 days. New replies are no longer allowed.