Clarity Service Management

Expand all | Collapse all

How to create average time report on query object

Jump to Best Answer
  • 1.  How to create average time report on query object

    Posted 01-03-2016 09:24 PM

    Dear All

     

    I would like to create average time report.

    I mean create report to show time status on ticket.

    Example Column 1  Status "Open", time = 10 min.

    Column 2  Status "In Progress", time = 60 min.

    ....

     

    Can you help me to select the query object  or you have best practice to create  average time report?

     

    Thank you,

    Yutthachai



  • 2.  Re: How to create average time report on query object
    Best Answer

    Posted 01-12-2016 05:51 PM

    Please refer to the following post regarding the KPI Ticket Data table:

    Reporting on KPI Data

    Once you have this feature enabled you will then have a table that contains the value of various ticket fields and the time they were updated. To build your report you would look for changes to the Status field and the time between updates to determine how long the ticket remained in that status.



  • 3.  Re: How to create average time report on query object

    Posted 01-21-2016 11:42 AM

    Hi - We're you able to resolve using James' suggestion? If so please mark his response as Correct Answer. Thanks! Chris