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.