You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
Hello,
I'd like to be able to automatically build a status report of work done by a person over the last month. This status report could provide backup for an invoice if someone had a question about what the person was working on.
I've found with the new updatedby() JQL function that I can build this report easily with the following code:
issuekey in updatedby(user, -30d)
What I'd love to be able to do is use a toggle or dropdown on a confluence page where I could choose the user and the time period. Then I don't have to build a report for each individual user.
I'd also love to be able to choose the dates, e.g., from the beginning of last month to the end of last month. I tried using startOfMonth() in the formula above, but it doesn't work.
Any thoughts on how I might automate these 2 pieces (the user and the time period)?
Thanks!
Laurie
Hi @lececere
I can help with the date piece - you can search between two specific dates (rather than using startofmonth()) - see the Functions Reference page for more details.
In relation to drop-downs - I've seen apps like this one before for Jira Dashboards - where you can add quick filters to the Dashboard which acts like a drop-down. It would still require some setup as you'd need to create the multiple queries for the drop-down options - but it would save you some real estate on visualising it.
Dynamically changing the JQL filter based on content from a Confluence page - not sure how possible that would be unfortunately.
Ste
Hi Ste,
Thanks for your response.
I've been working with the add-on you suggest, Rich Filters, for the last several months and absolutely love it! It allows tons of flexibility in reporting and filtering on dashboards.
Unfortunately, since the name of the person is within a function, I've confirmed with the rich filter folks that there isn't a way to get a dropdown to change that value. I could, as you suggest, create a static button for each individual. That certainly would be more efficient than creating a new rich filter and report for each person.
If anyone has additional thoughts, I'd love to hear them.
Thanks again Ste!
Laurie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The updatedby() is not functioning well in jira cloud. The result I got including user that has never updated anything on the ticket.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Frank Chee
Was this a one-off or a regular issue when using this function? And was this Classic or Next-Gen?
Ste
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Laurie! @lececere
You can automatically build a status report of completed work by an assignee over a certain period of time with Time in Status for Jira Cloud by SaaSJet.
With this add-on, you can not only automatically generate the report of the average time issues spent in statuses during a specific period of time, but also the report of the time that a particular assignee was assigned to each issue, the report of how long your issues has been staying in each status, how many times an issue has been in each status, and much more.
This add-on has an advanced filtering system by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).
Moreover, you can view your data in charts (Pie, Bar and Area Charts).
And, of course, you can export the data both as numeric report and graphical.
You can always try it for free, hope this will help.
Julia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.