Making a lot of assumptions:
1. Filter data for a week
2. Remove possible duplicate visits per week
3. Count unique dates, if < 7 then they did not visit every day in a week.
vague questions = vague answers
@flyingsohigh wrote:
hi, I have a sql question as below:
Given timestamps of visits, how to figure out how many people visit all seven days of a week on the location?
Thanks.