Epics Created where Story Point Created is not empty


I’m trying to get the below report to filter out any epics where Story Points Created is empty.

I’ve tried filtering the Story Points Created field but it doesn’t affect the Count of Epics field.

From the below data, the count of All Issues in the Count of Epics field would be 5 rather than 8.

The MDX for Count of Epics is:

([Measures].[Issues created], [Issue Type].[Epic])

Thanks in advance!

Hi @joejames ,

You can use the hidden measure “Issues with story points created” in a tuple with the Issue Type dimension “Epic” member. See the formula below:

([Measures].[Issues with Story Points created],
[Issue Type].[Epic])

See the eazyBI documentation page for more details on the measures available with the Jira Software integration - Jira Software custom fields - eazyBI for Jira.

Roberts // support@eazybi.com

Thanks @roberts.cacus that works great.
Is there a way to filter the Story Points Created to only show those story points that fall within the Epics with SP field??
Thanks again!

Hi @joejames ,

Try a similar approach to the previous one and create a new calculated measure with the Issue Type dimension “Epic” member and the measure “Story Points created”.

Roberts // support@eazybi.com