You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
is there a way to filter or create the workload report, only for the open tickets.
The default report shows all the ticket per user, even the closed, resolved or cancelled ones.
Where can I edit this or create another one that look the same as the default one, that display could be very useful.
Welcome to the community. Based on my knowledge that out of the box that we don't have the ability to edit or create another custom workload report in the UI.
Here are a list of references on out of the box reporting setup -
You will need to search Atlassian Marketplace (https://marketplace.atlassian.com/search?category=Reports&hosting=cloud&product=jira-service-management) for possible third party add-ons to achieve what you are asking for enhanced reporting needs.
You other options to generate the the content (not actual reports) will be using JQL search to obtain your results and then export them into Excel to generate the reports.
Hope this helps.
Best, Joseph Chung Yin
Jira/JSM Functional Lead, Global Technology Applications Team
if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including all JSM fields - much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
With these, you can build an interactive workload report like the one you're looking for in just a couple of clicks:
As every JXL sheet is powered by a JQL statement, you can also easily build cross-project reports, if this is something you might be looking for.
After questions just let me know,