I'm attempting to create a report that shows the average turnaround time of tasks closed within the last 30 days minus the weekends and a trend line for the last 13 weeks.
My first thought was I need to query 121 days worth of data so the first week of the 13 weeks (91 days) has 30 days worth of data. Create a group on the closed date for each week and then a sub group on the closed date by month.... I then realized that the subgroup wont have the actual 30 days worth of data because its a subgroup of a group that's grouped by week.
In the end, one data entry could be reported on in 4 weeks of data but I can't figure out how to accomplish this.
Any suggestions/ideas would be great.