Counting uniques on a week by week basis

0 votes

1 answer

2680 views

                          I've managed to find the unique # of session_ids within the first week of the the year with this query.  

How do I get each successive week's unique count up to the last week of June? 

    SELECT COUNT (DISTINCT session_id),
      MAX(timestamp_local)
    FROM
      myTable
    WHERE
      timestamp >= '2018-01-01'
      AND timestamp <= '2018-01-07'

Appreciate your help!
                        

Asked by spamdavy (11 rep)

Jul 14, 2018, 06:52 PM
Last activity: Oct 2, 2022, 12:04 PM

Counting uniques on a week by week basis

Related Questions