Right now we are demoing Jira Cloud, and we currently have an in-house process where our associates go and input a description of of their weekly work. I am hoping there is a report I can run for a Jira Cloud Kanban board that can provide me a list of work items assigned to myself. If so, this would be a strong argument for us going to Jira Cloud. There are some teams that are using SpiraTeam, and I know there is a way within that app to export tasks (work items) to an excel report.
Hello @Spencer Hale
Welcome to the Atlassian Community!
Could you please describe exactly what kind of statistics you want to display in your reports?
Also, to give you specific instructions on how to achieve it, I must know how you are registering your weekly work at the issues. Are you using a custom field or comments?
If you are just looking for a list of all issues assigned to you displaying the description of the work done on those issues in the last week, you can use the Advanced search mechanism of Jira (JQL) to return that information:
Let me give you a practical example or how this could be done:
Let's suppose you are using the comment sections to add the weekly work done in your issues. To be able to display the comment related to the last week at the report, you can use a custom field to return only the last comment added. These would be the steps:
assignee = currentUser() and status in ("In progress", "done") and updated >= startOfWeek() and project = "ABC-123"
Following the steps suggested, the query will display all the issues updated at the last week that are assigned to you in the status "In progress" or "Done" at your Next-gen project.
Additionally, you can export those issues in different formats if you want with all their related fields. To do it, just clicking at the Export button on the top-right corner of the page
Let us know if you have any questions.
You are welcome, @Spencer Hale
If you have any questions about the instructions provided while creating your report, please feel free to ask me directly in this question.
Now, if you need help to achieve something different from the initial question summary, please create a new question so other users looking for the same instructions can easily find the related content.
Jira is a powerful tool that helps teams to plan, manage, and report on their work. We love using Jira, especially for its ability to track issue progress. But how to monitor the...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event