I have a report at the moment that almost provides 100% of what I need, just 1 last annoying thing to sort out and I am hoping that you can assist.

 

   Database is a Remedy DB and at the moment I run a report that lists all calls that were a priority 1 or 2 throughout the course of their 'life'. This does work, in a way, and returns a list of calls but instead of showing the highest priority the call reached, it displays the priority it was resolved at.

 

   So if a call reaches a P2 and is then dropped to a P3 for monitoring whilst the fix is proved, the report will list it as it did reach 2, but it will only display the priority as a 3.

 

   Here is an example of what I mean. You will see that a number of calls are reported at their highest priority, as they were never reduced and therefore show at their highest priorty. You will see however that a few P3 calls are listed, so they must have been a P1 or 2 at somepoint, what I would like to know is if there is a way to display the highest it reached.

 

 

Create_Time	Priority	Case_ID_
01/09/2011  21:31:58	2	SD582659
02/09/2011  10:49:08	2	SD582727
03/09/2011  08:15:43	3	SD582831
05/09/2011  08:31:39	3	SD582917
05/09/2011  08:17:48	2	SD582918
05/09/2011  09:19:17	3	SD582957
05/09/2011  12:30:50	2	SD583083
05/09/2011  22:28:40	2	SD583232
06/09/2011  07:48:24	1	SD583242

 

 

 

Many thanks for any advice you can offer.