As I am rather new to CR, I'm calling in for your help.

I'm trying to achieve the following:

 

We log tickets with a startdate and on closure with a enddate. For every ticket there is another date; the suppossed solving date (here called appdate). All of these tickets can be logged by several groups.

 

I would like to get an overview like below:

 

                Total OPEN tickets    Tickets overdue 24hrs.   Tickets overdue > week

group 1                12                             2                                   4

group 2                  3                             1                                   0

group 3                28                             5                                   3

etc.

 

I'm really stuck here; the total open tickets is no problem but i'm struggeling with the other two categories: tickets overdue since 24hrs, and tickets overdue > week.

 

So the first columns shows all of the tickets which are not yet closed; the second column should show the number of tickets which are overdue since 24hrs (so difference between appdate and currentdate is 24 hrs.; the same for the last column only now it should show the number of tickets which are overdue more than one week.

 

The most elegant solution would be to present the data in a crosstab.

 

Can anyone show me the way?

Thanks in advance!

Raymond.