I am trying to implement a simple Leaderboard that will show the performance of my team.
What I am looking for is to rank team members based on their quality, where quality is calculated
from several completed Jira tickets against the number of rejected tickets.
The problem is that I am counting tickets using custom field (completed at), which is a date field
but for some reason, I don’t see all the tickets in the report if I compare them to the JQL filter.
I believe I am missing something straightforward, but I still can’t find a proper solution.
Important design decisions:
- Category and Time should be configured as Page
This allows us to change the view of the Leaderboard easily
- Time needs to show:
- WTD (Week to Date)
- T1W (Trailing 1 Week)
- T4W (Trailing 4 Weeks)
- Rows should list all Assignees that have tickets assigned to them (even if there are 0 completed)
As an example, here’s my configuration
// WTD Measure - This is used as a Page to set Time view Aggregate( [Time.Weekly].[Week].DateMembersBetween('1 weeks ago', 'today') ) // Completed Unit Measure // This seems to be incorrect as it shows different data from what I get with JQL filter -- annotations.disable_drill_across=true Cache( CoalesceEmpty( Sum( Filter( Descendants([Issue].Currentmember, [Issue].[Issue]), DateInPeriod( [Measures].[Issue Completed at], [Time].CurrentHierarchyMember ) ) ), 0 ) )