Exclude Epic issue type in Issue Resolution Days

Utilizing the sample report Issue Resolution Days Over Time with Trend and need to exclude the Epic issue-type. Issue By dimension (deleting the Epic type) does not produce the desired results.

Was able to resolve; here’s the Issue Type dimension calculated-member:

Aggregate(
  Except(
    --set of all issue types
    [Issue Type].[Issue Type].Members,
    --list of issue types excluded
    { [Issue Type].[Epic] }
  )
)
1 Like