How to create a dashboard with queries revolving around worklogauthor

Question

I'm trying to create a dashboard to provide data into how many Triage issue types we close in a given timeframe. I have queries to filter to Last Week and Current Week. I'm struggling to put together a query for a static filter to also show who logged work and which items the work was logged against.

My "closed last week" static filter:

Project in ("myprojects") AND issuetype = Triage AND resolution changed during (startofweek(-7d), endofweek(-7d))

My "closed this week" static filter:

Project in ("myprojects") AND issuetype = Triage AND resolved >= startOfWeek()

I created a filter that shows a few specific users for worklogAuthor but I'd like it to be a filter that returns the work logged for last week and current week, for any user that falls within the Closed Last week and Closed This week filter criteria.

Any help is appreciated!

John Funk · Answer

Hi Karl - Did you ever get this worked out? If so, what was the solution?

Renata_Getint · Answer

Hi there! 👋 Creating a dashboard with insights into worklog authors and items they've logged work against is a great idea for tracking team contributions! Here’s how you can refine your queries to achieve that: Step 1: Leverage worklogAuthor and worklogDate The worklogAuthor and worklogDate fields are key here. You can combine these with your existing filters for "Closed Last Week" and "Closed This Week" to add the dimension of logged work. For example: * Work logged last week: Project in ("myprojects") AND issuetype = Triage AND resolution changed during (startofweek(-7d), endofweek(-7d)) AND worklogDate >= startOfWeek(-7d) AND worklogDate <= endOfWeek(-7d) * Work logged this week: Project in ("myprojects") AND issuetype = Triage AND resolved >= startOfWeek() AND worklogDate >= startOfWeek() AND worklogDate <= endOfWeek() Step 2: Show Logged Work Per User If you want to filter by specific users or show data for all users, you can use: * For specific users: worklogAuthor in (user1, user2, user3) * For all users (to track every contributor): Simply omit the worklogAuthor condition. This will include all users who logged work within the specified timeframe. Step 3: Add Filters to Your Dashboard * Save these queries as filters. * Add gadgets like Workload Pie Chart or Filter Results to your dashboard. * Configure the gadgets to use your saved filters for "Work Logged Last Week" and "Work Logged This Week." Bonus: Advanced Insights To provide even richer insights, consider using Jira Time Tracking Reports or integrating with an analytics tool (like eazyBI). If you're looking for custom reports tailored to your team's workflow, platforms like Getint can also help with advanced data integration and visualization. 🚀 Let me know if you have further questions or run into any issues—happy to help! 😊

Adrián García González · Answer

Hi @Karl Reading , You can make use of the worklogDate to select those issues where time has been logged in that period. These could be the JQL queries: 1. Filter ‘Closed last week with worklogs’. Project in ("myprojects") AND issuetype = Triage AND resolution changed during (startOfWeek(-7d), endOfWeek(-7d)) AND worklogDate >= startOfWeek(-7d) AND worklogDate <= endOfWeek(-7d) 2. Filter ‘Closed this week with worklogs’. Project in ("myprojects") AND issuetype = Triage AND resolved >= startOfWeek() AND worklogDate >= startOfWeek() AND worklogDate <= endOfWeek() This would return the list of closed items where time was logged in during the selected time periods. If what you need is to get a report of the logged hours you can make use of a plugin from the Marketplace, I recommend Worklogs. I have experience and it is quite versatile, you can indicate the filter and it shows you the time logs in different formats and quite ‘’pretty‘’. I hope this is helpful, best regards!