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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 15, 2023 • edited

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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.


Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events