I have spent hours and hours reading questions, testing scenarios and attempting to put together what should in my mind be a relatively simple task. I can achieve everything I need in JQL with nested queries, but in Jira I can’t generate it in a report format - hence eazyBI. Some basic things are easy to do in eazyBI and I’ve had good success. Other things seem far from easy and it’s becoming quite frustrating. Let me try to explain this in simple terms:
I have eazyBI installed with Advanced Roadmaps. I am using a hierarchy of Initiative → Epic → Story. Task issue type is also on the same level as Story. Very straightforward.
I need a report that shows me all stories and tasks that are linked to an Epic (Epic Link), where the AffectsVersion on the Epic = X and the parent link is empty.
So this seems pretty simple.
- Find all Epics where AffectsVersion = X and parent link is empty.
- Return a list of Stories and Tasks under these Epics.
- Add some dimension on the measure, to segregate by team for example.
Why is this so hard to accomplish? I’ve tried using the parent link on pages, the affects version on pages, I’ve tried using them as columns, tried drilling through and selecting the value - nothing works.
Please help - I’m losing my patience with this tool.