Hello,
I have setup a report to show among other attributes the "SolutionInMinutes" for closed tickets.
However, in the report I am getting "0" for every ticket. All tickets have a Service and SLA assigned.
I cannot find the reason for this, any suggestions ?
thank you,
Spyros
Problem with Reporting the SolutionTimeInMinutes
Moderator: crythias
Problem with Reporting the SolutionTimeInMinutes
Last edited by sanemogi on 19 Jul 2011, 17:24, edited 1 time in total.
Re: Problem with Reporting the SolutionTimeInMinutes
Just for update, these are the attributes for the Report:
Attributes to be printed:
Number
Ticket#
Title
Created
Close Time
Queue
CustomerID
Service
SolutionInMin
CallerFrom
CallerID
Ticket Type
Attributes to be printed:
Number
Ticket#
Title
Created
Close Time
Queue
CustomerID
Service
SolutionInMin
CallerFrom
CallerID
Ticket Type
Re: Problem with Reporting the SolutionTimeInMinutes
Is the ticket already solved? If yes the value will be 0 as you described. Try SolutionDiffInMin to get a value showing the difference between your solution time and the escalation time.
If positive you were faster, if negative you were slower
If positive you were faster, if negative you were slower
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Problem with Reporting the SolutionTimeInMinutes
The problem was solved just by putting a value in the "Escalation - Solution Time:" in the SLA configuration.
Previously I have left the "Escalation - Solution Time:" = 0 , meaning no escalation. That it seems caused the SolutionTime not to be calculated.
Previously I have left the "Escalation - Solution Time:" = 0 , meaning no escalation. That it seems caused the SolutionTime not to be calculated.