Total time spent on tickets.

[Prasanth Sai Shiramshetti]

How to pull a report for total time spent on all the tickets for an Organisation. For an example,  if I  have 3 clients. for an instance, 20 tickets were created and closed for A client, 25 tickets reported for B client and 10 tickets reported for C client. Here my question is how to pull a report in order to get the total time spent on all the 20 tickets for A client from open to closed status ?

[Moses Thomas]

@Prasanth Sai Shiramshetti You  can  do something like this  make your have the time tracking enable, script runner for Jira.

You  can write the JQL query to  get  it

project in (CompanyA,CompanyB,.....) AND issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")

best!

[Prasanth Sai Shiramshetti]

@Moses Thomas could you please explain me more elaborately as I am not much proficient with JIRA. Where I can write this query ? Can you please provide me the navigation path or the screen shots. Thank you.

[Moses Thomas]

@Prasanth Sai Shiramshetti You can  type it in the search for issues  box advanced mode.

[Prasanth Sai Shiramshetti]

@Moses Thomas

I need to find the time for all the ticket for a Company based on Created Date and Act QA Completion Date. Is it possible? if yes, can you provide me the query for this. Thank you

[Prasanth Sai Shiramshetti]

@Moses Thomas 

I would like to know the time difference between two fields in JIRA for all the tickets completed for one customer at a time.  One is Actual QA Completion date and the other is Created date. This would give me the total handling time of the ticket. 

For ex:  In the above screenshot, I would exactly require the difference of Act QA Completion date which is 28/May/2018 and Created date which is 18/May/2018. The result would be approx 10 days. SO, I need this operation to be performed for all the tickets for one customer at a time. When I tried, I have got the below error. Please provide me the solution for this requirement. Thank you.

[Moses Thomas]

@Prasanth Sai ShiramshettiYou need to  install script runner  plugin for JIra

[George Mihailoff]

This addon provides totals for time spent on tickets https://marketplace.atlassian.com/apps/1218809/quantify-ai. Time is calculated automatically based on statuses, and you can adjust what to include in the calculation.