I have a collection where people write critiques on songs. One person may have several entries because a person will critique multiple songs. I need to count the number of people that have critiqued songs. This passed month we had 13 songs submitted for critiques. There were 127 critiques made by 18 different people. I had to count the number of people manually. I would like to have this counted and displayed on a stats page. I have figured out how to count the number of songs and critiques , and display them. But the counting the number of people, because of the multiple entries, is proving to be a problem. Honestly I don’t even know where to begin. My site URL is https://www.houstonsongwriters.net/
Any help would be greatly appreciated. I am not very good at posting like this, so if more information is needed please let me know.
Without an insight in your db-setup (especially references) we cannot begin to help you. So tell us “these are the fields for the songs”, “this is the Critiques collection layout”, etc, and “field x refs field y”.
Hi Giri, thanks for responding. Below is an example of the database. These are some of the fields, at least the ones that are important. There are no references between fields. The collection is called “Song Critiques”.
In this example, there are nine critiques given by five different people. I already have a page that counts the number of songs and the number of critiques. What I am trying to do is count how many different people critiqued a song, five in this case. Sorting allows me to group the "critiquers " together but not add up how many different people have critiqued. Let me know if you need more info. I would be grateful for any help.
Have you tried https://www.wix.com/velo/reference/wix-data/wixdataquery/distinct ?
Thanks for the suggestion Giri! I looked at this and got what I wanted. Sometimes I just need someone to point me the right direction. Thanks again. Have a good day, be safe and stay healthy.