Help
Please
We are trying to write a report in CR9 against our remedy database ARS 5.
We need to find out the 1st time a call was responded to, and pull this data out and measure it against our sla's
The problem is the most obvious field to use is over written when a certain change is made to a call.
Thus the field when used produces rubbish figures.
Our second attempt uses a Nthsmallest function to pull out the first two entries from another table.
This seemed to work but on checking the report was pulling out random actions eg no 3, no 4 no5 etc.
Please can anyone help, as we are going bonkers here.
cheers
Richard
Please
We are trying to write a report in CR9 against our remedy database ARS 5.
We need to find out the 1st time a call was responded to, and pull this data out and measure it against our sla's
The problem is the most obvious field to use is over written when a certain change is made to a call.
Thus the field when used produces rubbish figures.
Our second attempt uses a Nthsmallest function to pull out the first two entries from another table.
This seemed to work but on checking the report was pulling out random actions eg no 3, no 4 no5 etc.
Please can anyone help, as we are going bonkers here.
cheers
Richard