I'm really hoping someone can help me. I'm using Microsoft SQL Server Management Studio to do this.
I have a table with an ID, start_date, and end_date. Example would be:
123456789 | 6/1/16 | 9/30/16
The date range is the period of time the ID is active. In this example we would say that ID 123456789 has been active from 6/1/16 through 9/30/16. This table has many thousands of records. The ID is not a key.
I have a need to know what was the average distinct count of daily active users per quarter. Any suggestions?