How to report Time to response vs Time to resolution

[serge calderara]

Dear all,

I have different service request which runs and handle correctly in Jira with an SLA which start when request is created and Stop when request is resolved.

Based on that I try to show on the report Time to resolution vs Time to first response but the problem I have is that I have the same curve which are exactly the same for both label as seen below :

The querry for those 2 series are as below :

Did I miss something which I do not do correctly ? 

Note : When I add the time to resolution field on my request form it has no value

Thanks for help in order to display correctly this report

regards

[Fahad Siddiqui · Accepted solution]

@serge calderara kinldy remove the filter by quire and then check.

[serge calderara]

@fahad what do you mean by removing the filter?

[Fahad Siddiqui]

@serge calderara just try to empty Filter by don't add any quires and see the result.

Let me know what you see in the graph

[serge calderara]

@Fahad Siddiqui by doing this I have a different curve which is for all request of any project but still Time to response and Time to resolution are 100% overlaped, which is nearly impossible

[Fahad Siddiqui]

@serge calderara if you observe the above total is coming same.

I mean time of response and ticket of resolution.

Can you select some other days or months were the totals is showing different and check

Your issue is that you have selected the series created for both

time of response and ticket of resolution.

Keep created in series for time of response

Keep resolution in series  for ticket of resolution

[serge calderara]

@Fahad Siddiqui whetever data range I select both value shows the same

[Fahad Siddiqui]

Do one thing as i said before.

Create new series 

Select created in series for label  time of response

Select resolution  in resolution for label  ticket of resolution

then add the filter which you added before and see this will fix your issue

[serge calderara]

@Fahad Siddiqui , hahaha I get different data now, my mistake I guess is that on both of my series I have set "Created"

[Fahad Siddiqui]

Yes that was the issue, anyways if my answer have helped you please accept the answer so this will be closed. have a nice day

[serge calderara]

@Fahad Siddiqui what is the uint of the Time to Resolution and Time to first response values ?
are they days ?

[Fahad Siddiqui]

@serge calderara this depends open your organization SLA.

First Response Time is calculated by simply subtracting the time of the customer request from the time of the initial reply. To see more of a trend over time, calculate the Average First Response Time by dividing the sum of all First Response Time by the number of resolved tickets

[serge calderara]

@Fahad Siddiqui what do you mean ?
any sample ?

I have the feeling from my graph that the value correspond to the number of issue ( see below )

If I click on the last green point, it shows 4 records which is also corresponding for the 5 count value of time to resolution. Same thing if I click the red point, value seems to match number of issue type count

[Fahad Siddiqui]

@serge calderara please share your requirement what you want to show in report.

[serge calderara]

@Fahad Siddiqui I try to get the following :

Requirement:

A first curve which shows the time which is spend before the first answer is given to user for each issue return and  its average

Then a second curve which shows the time spend until resolution for each issue return

Remark :
using the way we try so far it looks like it simply count the number of issue for each days as it is exactly corrsponding to the counter. This is what I felt is wierd and did not find the logic

My SLA is build as below :

[Fahad Siddiqui]

@serge calderara The above is new requirement, i would suggest to post new question so anyone can help you out. Related to your first problem if you believe its fixed then please accept the answer so that it gets closed.