Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

I need a JQL to show each assignee utilization percentage per week per project

Amr Darwish
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 14, 2023

For sake of JIRA reporting I need a JQL to:
1- Show each assignee utilization percentage per week per project.
2- Compare utilization % "Planned" versus "Actual".
3- Show resources utilization, Who's doing what and where and how many hours.

2 answers

0 votes
Nataliya Vasyliv_Reliex_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 15, 2023

Hi @Amr Darwish 

Not sure that JQL could show you the whole picture. If you consider using plugins I could recommend ActivityTimeline plugin is a resource management add-on for Jira that provides a resource utilization plan in a single view.

You can select a project, team, or several employees by skill or position. Then you can just drag-n-drop the task to assign and schedule. The system will automatically calculate the workload or work log or both (depends what you will need).

Screenshot 2023-05-15 at 12.37.05@2x.png

Also, there is an ability to create numerous reports based on information from Jira and ActivityTimeline:

Screenshot 2023-05-15 at 12.37.41@2x.png

The app provides a special Resource Utilization Report that helps to assess and plan the teams' workload.
You can try a trial or we can provide a demo session for you and your team if needed. Feel free to ask any questions if needed.
Best, Nataliya, ActivityTimeline Team
0 votes
Ivan Lima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 14, 2023

Welcome to the Atlassian Community.

There are lots of moving parts to your requirements here. In Jira, JQL will get you a list of matching issues based on what you're looking for, and it doesn't natively support calculations. You'd need to look into marketplace apps. I have achieved something similar using Tempo timesheets and eazyBI, but you can explore many other great apps that can give you similar results. I'm sure others will chime in and share more insights into this.

Cheers,
IL.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events