Building a dashboard for team members that cross multiple projects across the organization

[Mike Brouillette]

Folks,

  I have an interesting problem I am trying to solve.  I'm trying to build a dashboard for a senior manager who has team members within his organization that are loaned out to different projects on totally different boards across the organization and he does not have ownership of those projects in most cases.  No one organization owns all these projects so there is no central rollup of these projects and his people might have a couple stories across a dozen separate projects at any given time.

What I would like to do is give him a separate page for each employee showing how their time is spread out,

.  What it is they are working on

.  What project these stories are attached to

.  Average time the story are open or have been opened for

.  anything else I can think of

Any ideas?  I would like to do this without having at buy an add-on product too.

Thanks in advance,

Mike B

[Chris Buzon]

This should be possible through JQL and a widget. Your Manager can use a dashboard or embed widgets into a confluence page if they prefer.

Since the common factor here is assignee, this should be relatively easy to set up with the Filter Results and Issue Statistics widgets.


assignee = <X> and issuetype in (bug, task) and statusCategory != Done
(this, in the issue statistic widget) will give you a breakdown of the incomplete work that assignee has on them.

You could then modify this query to return only closed tickets within the last 2 weeks (there are a lot of ways to do that in JQL), like this:

assignee in (userID would go here, since jira doesn't display names in a query) AND resolved >= -2w

You might find some of the average time requests are easier to do through the reports built into your scrum/kanban boards (cumulative flow for example).  They can be altered using Quick filters, so if you want to see the data for just 1 person on a team, create a quick filter on that board with assignee = <userID> and then in the reports you can select it.