Forum Discussion

Rck7's avatar
Rck7
Helper II
8 years ago
Solved

How do I calculate average Response Time and Resolution Time ?

Hello Friends, I have an Issue Table, with IssueID, IssueDate, StartDate , Resolved Date as Columns. I would like to calculate the a) the average First response time(in hours), b) average re-solut...
Need Help
Show and Tell
  • zenmemo's avatar
    zenmemo
    8 years ago

    Hi Rck7, is this what you're looking for?

     

    Average Response Time = DATEDIFF(StartDate,ResolvedDate,HOUR)

  • zenmemo's avatar
    zenmemo
    8 years ago

    Rck7Now if you're selecting averaging the response/resolution times in conjunction with those measures, that should do it. See sample below. Otherwise, if you attach your file perhaps, I or someonelse can look at what else is causing it.

     

     

zenmemo's avatar
zenmemo
Helper I
8 years ago

Hi Rck7, is this what you're looking for?

 

Average Response Time = DATEDIFF(StartDate,ResolvedDate,HOUR)

Rck7's avatar
Rck7
Helper II
8 years ago

zenmemo  Thanks for the help. Additionally, is there a measure to  calculate Average Resolution speed from my table data? 
for Average Response time =  DATEDIFF(IssueDate,StartDate,HOUR) and 
for Average Resolution Time, is it DATEDIFF(StartDate,ResolvedDate,HOUR) ?

Thank you. 

 

  • zenmemo's avatar
    zenmemo
    Helper I
    8 years ago

    Rck7

     

    Perhaps I'm oversimplifying it but would an averagex function work?

    That is,

    AVERAGEX(Table Name,IssueDate,StartDate,HOUR))