Hi all,

I am far from a SQL expert, but this feels doable and I just don't know how.  If I had a table that looked something like Stage History..

Record Id	Start Date	End Date	Stage	Duration (Days)
11111	10/01/2020	10/21/2020	Needs Analysis	20
11112	09/20/2020	12/03/2020	Needs Analysis	74
11113	11/10/2020	12/23/2020	Need Analysis	43

What I'd like to do is make a Line Chart where  
X Axis = Week of Year

Y Axis = Count of Records while in Needs Analysis
So each record would add to the line while between the Start and End dates. 

My thought is I'd need to create a query to create a row for every day it's in the duration?

Any one have any suggestions on how to accomplish this?

Thanks!