We have a 3 level hierarchy as follows in the Advanced settings:
[[jira.issue_hierarchies]]
name = “Portfolio Epic”
all_member_name = “All Issues by SAFe Epic”
levels = [
{name=“Epic”,key_column=“customfield_10410”,issue_type=“Portfolio Epic”},
{name=“Feature”,key_column=“epic_key”},
{name=“Story”,key_column=“epic_parent_key”},
{name=“Sub-task”,key_column=“subtask_key”}
]
I am trying to add an Issue Dimension Calculated member to filter the Portfolio Epic’s that have > 0 Feature’s but this calculation is not working:
I get the following error:
Formula is not valid:
Member expression ‘Filter([Issue.Portfolio Epic].Members, (Count([Issue.Portfolio Epic].Children) > 0))’ must not be a set
The “must not be a set” errors just means that you are returning a set and eazyBI is not sure what you want to do with it. So you must use of the aggregators.
For example, Aggregate(), Count(), Avg(), Sum(), Median().
Thank you for the quick reply GvidoN, but when I use Aggregate it then groups the Epics which defeats the purpose of trying to filter and only select the Epics with at least 1 Feature:
Sorry @GvidoN I am not sure how to do this - when I have unselected all other members all I have is my calculated member which i cannot expand to see the Epics within that have Features, all I see is this. I need to not Aggergate them but just filter them.