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; } } }

JQL to list out the time spent and the original estimate for a ticket.

prabu m

We have created a task (common task like learning process) in the Jira, and multiple users are added a time spent in that task. For example,

User 'a' added 3h for 21/05/2020 and

User 'b' added 2h for 22/05/2020 again

User 'a' added 5h for 22/05/2020

I want to generate a report (write a JQL query) to calculate the user 'a' ,how much time spent in that task same for user 'b' also.

Accepted answers

Jack Nolddor [Sweet Bananas]

Have you tried Team Worklog Reports ?

Regards

All comments

Jack Nolddor [Sweet Bananas]

Have you tried Team Worklog Reports ?

Regards

prabu m

@Jack Nolddor [Sweet Bananas] No, is it possible from JQL? because I need to show this in our Jira Dashboard?

User wise time spent for the particular Jira id.

Jack Nolddor [Sweet Bananas]

JQL has not groupBy operator, so you cannot sum() worklogs.

To report worklog on Gadgets you can use Time Reports (PAID) third-party app.

Regards

prabu m

@Jack Nolddor [Sweet Bananas]Thanks, Let me check the app.

Ligia Merciu

Hi there,

You can use

worklogAuthor in (user a, user b) ORDER BY key ASC/DESC

and select the Σ Time spent column to display.

Jack Nolddor [Sweet Bananas]

I believe the field Σ Time spent does not split the results by users which is the OP requirement.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql