Count Distinct Feature

Hi Adalo folks. I have a feature I’m building and I hit a wall. Is there a way to do a count distinct? The feature is to count the number of stores a user visits within say every quarter. The user may visit a store many times within a quarter so I only want to count that store one time. Thanks in advance.

I would create a “Visits” collection in the database and set up a many-to-one relationship with the User.
Each time a visitor enters, a new record is created and linked to that specific user.

If there’s a need to restrict access, I’d handle it with an automation in Make that runs based on the relevant date.

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