Skip to Content
Former Member
Sep 22, 2010 at 06:16 PM

Grouping but leaving data available for other groups


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.