Ignore duplicates in counting

i have an app where people and give each other reviews. Each person can review each other multiple times depending on category.

I want to get a count of each person he reviewed. Meaning if I review someone twice, it counts only once.

I can get a count of all his reviews. But I don’t know how to ignore duplicates if he reviewed the same person multiple times.

How can I do this?

try adding a filter to the count:

current review user > email is equal to > current user email is less than 2

Something like that it depends on your database collections name…

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.