Build monthly status report from updatedby()?

[lececere]

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)

https://confluence.atlassian.com/jirasoftwareserver081/advanced-searching-functions-reference-970611548.html

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

[Ste]

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

[lececere]

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

[Frank Chee]

The updatedby() is not functioning well in jira cloud. The result I got including user that has never updated anything on the ticket.

[Stephen Wright _Elabor8_]

Hi @Frank Chee 

Was this a one-off or a regular issue when using this function? And was this Classic or Next-Gen?

Ste

[Frank Chee]

Regular issue in next-gen project

[Stephen Wright _Elabor8_]

Hi @Frank Chee 

Can you share an example of the JQL you used, with the function above?

Ste

[Julia Denys [SaaSJet]]

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

[lececere]

Thanks @Julia Denys [SaaSJet] for your response.

We aren't using time tracking right now.