Hi All! I really hope someone can help me. I need to develop a report based on year-to-date data, grouped by week.
For each week I need to count the number of open problem tickets. For instance, if the report runs today and includes a problem ticket that's still open that was originally opened 6 weeks ago, that ticket needs to be counted each of those 6 preceding 6 weeks (not just in the week that it was opened). Hope I properly explained what I'm trying to do.
Can I do this in Crystal? Thanks in advance...
For each week I need to count the number of open problem tickets. For instance, if the report runs today and includes a problem ticket that's still open that was originally opened 6 weeks ago, that ticket needs to be counted each of those 6 preceding 6 weeks (not just in the week that it was opened). Hope I properly explained what I'm trying to do.
Can I do this in Crystal? Thanks in advance...