Custom Chart for Worklogs

Former user

I am working on a Custom Chart gadget for our development team. The goal of the gadget is to show their (current user's) worklog totals for the week.

At first I had the following settings: 

Chart Type - 2D Chart

Source = Custom JQL: worklogAuthor = currentUser() 

Chart By = WorkLog Date

Group By = Key

 

This works great except when another user has a worklog on the same day and same ticket as the current user. In this case, the other users' worklog total is included in the result. I can understand this, as the JQL is querying for issues, not necessarily worklogs.

Replacing Group BY: Key with Group By: worklogAuthor shows the breakdown, but we don't want the current user to see other users' worklogs. 

 

Any suggestions on how we can build a gadget in a dashboard that shows a current user's worklogs per ticket per day?

 

Sushant Verma

Hi @Katelyn O_Brien 

Welcome to the community!

To build a gadget that shows a current user's worklogs per ticket per day, you can make use of Jira's built-in gadgets and customize the settings as follows:

1. Add the "Filter Results" gadget to your dashboard:

2. Configure the "Filter Results" gadget:

In the "Filter" field, enter a JQL query to filter the tickets you want to include in the gadget. For example, you can use: "worklogAuthor = currentUser()".

3. Add the "Two Dimensional Filter Statistics" gadget to your dashboard

4. Configure the "Two Dimensional Filter Statistics" gadget
 
In the "Filter" field, choose the same JQL query used in the "Filter Results" gadget.
In the "Statistic Type" section, select "Worklog" from the dropdown menu.
In the "Group By" section, select "Issue" and "Day".

With these settings, the "Filter Results" gadget will show the filtered list of tickets for the current user, and the "Two Dimensional Filter Statistics" gadget will display the worklog totals per ticket per day for the filtered tickets.

Hope it will help!

Regards,
Sushant Verma