Forum Discussion

KrishKK's avatar
KrishKK
Copper Contributor
Mar 10, 2026

Counting distinct values

I’m trying to create a view but I’m struggling to find a solution to this issue.

I need a method that counts multiple visits to the same location as one if they occur within 14 days of each other. If there are multiple visits to the same location and the gap between them is more than 14 days, then each should be counted separately.

For example, in the attached screenshot:

Brussels had visits on 08/05 and 15/05, which are less than 14 days apart, so this should be counted as one visit.

Dublin had visits more than a month apart, so these should be counted as two separate visits.

 

Could someone please guide me on how to achieve this?

Thanks.

 

No RepliesBe the first to reply