Would like to build a report called "team focus"

So, I have several teams. Those teams have 6-7 team members on average.
While teams have sprint boards and all that in terms of day-to-day operation, what I’d like to build is report of longer period on where focus goes.

Example source data:
Epic 1 → Task 1 (Member A, Team 1)
Epic 1 → Task 2 (Member B, Team 1)
Epic 2 → Task 3 (Member C, Team 2)

Such data is collected daily.

View1: Epic point of view
Build day over day overview of:
Epic 1 (regardless of which task) total team members focused on that. e.g. 2members * 8h = 16h for that day.
Epic 2 (regardless of tasks) total team members. e.g. 1 member * 8h = 8h for that day.

View 2: Team view
Team 1 → Epic 1 → Xhours
Team 1 → Epic 2 → Xhours

And this is on a daily bases.
Any hints how could I go about building this.
Btw I’m sure this would make just an amazing default/example template within eazyBI.

Hi, @Julian_Davchev

I sincerely apologize for the delay in my response.

To generate a focus report for Epics and Teams, considering Team members working on Epic Tasks, please follow these steps:

Step 1: Define team members
Start by defining your Team members, using Task Assignee as Team members. You can achieve this by adding user groups as aggregated members in the Assignee dimension. A visual representation can be seen in the image below:

Alternatively, a more efficient way to create the teams of the Assignees is by creating a new hierarchy within the Assignee dimension. You can find more information in this community post created by my wonderful colleague Zane: How to Create a Team of Assignees.

Step 2: Choose Your View You can create a report that showcases both Epic and Team-level perspectives using just one report by altering the order of dimensions in the rows:

  • Epic Point of View: To view the overview from an Epic perspective, begin by adding the “Issue” dimension at the Epic level in rows, followed by the “Assignee” dimension (at the desired level, whether it’s individual users or teams).
  • Teams and Their Epics: If you prefer to see Teams and their associated Epics, initiate the report by selecting the “Assignee” dimension in rows, followed by the “Issue” dimension at the Epic level.

Step 3: Create a Calculated Measure To calculate hours for Team members involved in Epics, kindly create a new calculated measure using the following formula:

      DescendantsSet([Assignee].CurrentHierarchyMember, [Assignee].CurrentHierarchy.Levels("User")),
      [Measures].[Tasks] > 0
      [Assignee].CurrentHierarchyMember.Name <> "(unassigned)"
) * 8

Thank you for your patience.


Ilze support@eazybi.com