nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 ?

Accepted answers

All comments

Moses Thomas_08kyb0

@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_08kyb0

@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

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

report