How to group logged hours by user into custom blocks with drill-down by epic and task?

Questions & Answers
1

Hi everyone,

I’m trying to build a report in eazyBI where I can group the logged hours by user into custom blocks (e.g., “Juan Perez – 32 hrs” and “Ricardo Barcenas – 20 hrs”). Each of these blocks should be expandable to show:

  • The epics where the time was logged within that block.
  • The related tasks under each epic with their respective logged hours.

The expected structure would look something like this:

  • Juan Perez | 32 hrs
    • Epic 1 | 20 hrs
      Task A | 10 hrs
      Task B | 10 hrs
    • Epic 2 | 12 hrs
      …
  • Ricardo Barcenas | 20 hrs
  • Cynthia Salinas | 20 hrs
  • Sofia Vazquez | 20 hrs
    …
2

Hi, @itselvzz

Welcom to the eazyBI community.

Please use the Logged by dimension together with the Issue dimension and select the Epic hierarchy. Epic hierarchy allows for expanding the hierarchy and seeing what’s under the Epic.

Also, it’s possible to define a new Issue Hierarchy, to define the one you desire. Please read here: Additional Issue hierarchies

For example

[[jira.issue_hierarchies]]
name = "Epics Issues"
all_member_name = "Epics Issues"
levels = [
{name="Epic",key_column="epic_key"},
{name="Parent",key_column="epic_parent_key"},
{name="Sub-task",key_column="subtask_key"}
]

Please write us at support@eazybi.com if this is not what you were looking for.

Kindly,
Ilze