Count of issue with due date between two dates and rolling them up

I’m trying to create a report Like this


where the title is a higher level in my “Advanced Roadmap” hierarchy
the report should look into all the due date of all children and roll up the count to the higher level if the dates is between two pre defined dates as shown in the above photo.

@Tamer
See how to import custom hierarchy in “Issue” dimension to group issues by Advanced Roadmaps levels.
https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/advanced-roadmaps-custom-fields
Once hierarchy is enabled in “Issue” dimension you could select the measure “Issues with due date” and they should be rolled up automatically.

And see how to create 2-week hierarchy in Time dimension to group results by 2-week periods.
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/time-dimension#Timedimension-AddcustomhierarchiestoTimedimension

Martins / eazyBI

1 Like

@martins.vanags

Awesome, that solved my issue, I wasn’t thinking in this direction, Thank you so much for your help and support.