1 of 1 people found this helpful
I don't know of a full walkthrough, but I can provide a few pointers about how I would go about putting this together. For starters lets assume that each project is assigned to an individual user. I would use a date table (in this case all you would need is a table with a continuous list of dates, so for the sake of simplicity lets assume that this table has a single field, [Date]) so that dates for which no project is starting or ending still show up in your chart. I would then left join that to your project data set (assuming a single row per project) using the conditions that [Date] >= [Project Start Date] and [Date] <= [Project End Date]. This will create a set of rows for each project such that there is one row for each day that project was active. You can then create a chart showing SUM([Number of Records]) by [Date] with a filter by [User] to show what you want.