It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Build monthly status report from updatedby()?

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

2 answers

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

Like Ste likes this

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

Thanks @Julia Denys [SaaSJet] for your response.

We aren't using time tracking right now.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

888 views 7 24
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you