Pretty new in ServiceDesk, so maybe a stupid question.
In a report, I have the "time to status from starting" as a column, only for the "resolved" status.
Now: I need to have a "consolidated" view:
- everything resolved below 1h (3600)
- between 1-8h (3600-28800)
- more then 8h (28800)
Creating a calculated column with
IF [ReportProcessStatusHistory.TimeToStatusFromStarting] < 3600 THEN
"<1h" ELSE
IF [ReportProcessStatusHistory.TimeToStatusFromStarting] < 28800 THEN
"1-8h" ELSE
">8h"
ENDIF
does not work, as the field does not seem to be numeric.
Any idea how to handle (preferably in the reporting tool, not via SQL statement)?