I’m trying to count how many unique enteries in a database’s column… For example, If I have an entry for city, I want to return the number of different cities. I would think to use .count() but how would “skip” cities entered more than once? wixData.query("Faith-basedorganizations") .eq("city…

how to count unique entries in database

eglass April 28, 2023, 4:49pm 3

Thanks! oddly it returns 10 cities, and when I count them there are 8

Topic		Replies	Views
wix collections Ask the community code , question	5	281	January 3, 2019
Count the amount of times a text is in the database Ask the community code , question	1	161	June 11, 2018
Count () column based on fieldkey Ask the community code , question	1	69	February 27, 2021
unique field in database Ask the community code , question	1	596	January 23, 2019
Counting elements in database collection Ask the community code , question	7	2093	July 18, 2020