Ignore duplicates in counting

[trble]

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?

[njimmy10]

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…