How to build report that displays Epics with estimate and time spent

Hi

I’m new to eazyBI and need help building the following report.

  • Display only Epics by various teams / Components
  • In separate columns, display the aggregate estimated time and time spent for the tasks, stories associated with each Epic for the years 2023 and 2024

I want it to look similar to the the attachment.

I built this report but it isn’t at the Epic level but at the task level. I clicked the “Epic” button under “All hierarchy level members” in the “Issues” Dimension but it doesn’t convert to Epics. Can this report be built without any “coding”?

Hi @JeffA

You are on the right track with the Issue dimension Epic hierarchy!
You may want to try one more time to add it to the report rows:

You may use standard measures “Hours spent” and “Original estimated hours” to show the aggregated values of estimated hours for the epic’s issues created during the selected time period and hours logged during the selected period.

If you want to limit the report only to tasks (not counting sub-tasks, other issue types, and epic values themselves), add the “Issue type” dimension as a Page filter and select “Task.” Epic issues will still be shown as containers to display aggregated value over tasks.

Best,
IlzeLA, support@eazybi.com