Hey everyone. I’m pretty new to Corvid and can use some help with a program I’m trying to put together. I have a database that I’ve set up with text values assigned to different columns. I’m trying to find some way to write a wixData.query command that can tell me the most common value in a partic…

Jack, you could use wixDataAggregate like the following. The having statement is only necessary if it’s possible that the pets field could have no value in some of the records. Doing a descending sort will place the one with most common value (“cat” in your example) in the first place in th…

Return most frequent value from a Query

Ask the community

gasstationjack December 17, 2020, 6:33pm 3

That works perfectly. Thank you so much!

Topic		Replies	Views
Counting Values in a Database Ask the community code , question	5	984	October 20, 2018
wix collections Ask the community code , question	5	281	January 3, 2019
Database find MAX value Ask the community code	4	380	December 24, 2018
Use wixData.query results as text Ask the community code , question	2	595	August 28, 2019
using a value from a collection Ask the community code , question	8	1744	December 23, 2017

Return most frequent value from a Query

Related topics