How to create a dashboard with queries revolving around worklogauthor

[Karl Reading]

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!

[Renata_Getint]

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

1. Save these queries as filters.
2. Add gadgets like Workload Pie Chart or Filter Results to your dashboard.
3. 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]

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!