Epic reports - Hours Spent

Hi
I would like to create a report like
image

I would like to create a new calculated member to select Epic where Epic Name match “Config”
Calculated member in Issue.Epic
I succeeded with Issue

Aggregate(
  Filter([Issue].[Issue].Members,
  [Issue].CurrentMember.Name MATCHES ".*Config.*"  
  ))

I failed with the formula

Aggregate(  
  Filter([Issue.Epic].[Parent].Members,
  [Issue.Epic].[Parent].CurrentHierarchyMember.Name 
  MATCHES ".*Config.*"  
  ))

for Hours spent - I use [Measures].[Hours spent] or should I use “Hours spent with sub-task”
for Issue count - I use [Measures].[Issues created]

please, could you help me with it
thank you ahead

Hi, @DKostiuk

Welcom to the eazyBI community.

You are so close! You need to use the Epic level in the Issue dimension. Please find the updated formula:

Aggregate(  
  Filter([Issue.Epic].[Epic].Members,
  [Issue.Epic].CurrentHierarchyMember.Name 
  MATCHES ".*Config.*"  
  ))

About using “Hours spent” and “Hours spent with the sub-task”. If the report is based on Epics, then I would suggest “Hours spent with subtasks”, this will include all the Hours logged under Epic’s children. Please read more about “Hours spent” and “Hours spent with the subtasks” in our documentation under Measures, here: Jira Core measures and dimensions

Kindly,
Ilze