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.

     

     

Rck7's avatar
Rck7
Helper II
8 years ago

zenmemo Nope. I am not sure if my measures are correct? 

zenmemo's avatar
zenmemo
Helper I
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.

 

 

  • Rck7's avatar
    Rck7
    Helper II
    8 years ago

    HI zenmemo, 
    When I  use the DATEDIFF function to calculate the Response Time I am getting the result as 0:00 having my Data Format as 13:30(H:mm) as shown in the below images:



     

     

     

    Instead, I am using, 
    1. Response Time = Issues[IssueDate] - Issues[StartDate] for calculating RT values for my column. 
    2. Resolution Speed = Issues[ResolvedDate] - Issues[StartDate] for calculating RS values for my column.
    For calculating Averages, I created the following measures, 
    Avg RS = CALCULATE(AVERAGE(Issues[Resolution Speed]), ALLSELECTED(Issues[IssueDate]))
    Avg RT = CALCULATE(AVERAGE(Issues[Response Time]), ALLSELECTED(Issues[IssueDate]))

    The result Graph that I am getting is:



    What are your thoughts on it? 

    Kindly, let me know.
    Thanks. 

    • zenmemo's avatar
      zenmemo
      Helper I
      8 years ago

      For the average measures, have you considered changing the data type to whole numbers?

      • Rck7's avatar
        Rck7
        Helper II
        8 years ago

        zenmemo No, I am using  DateTime as the Datatype for my columns and calculating the average of my columns(as mentioned ear;ier). 
        Below, is the format that I am using for my columns:
         

        Thanks.