Hello community. I have a list with tickets of issuetype Feature. Below the feature there are subtasks of type qa effort and development subtask with the relevant times.
What i need is to be able to select from the list a feature ticket with its relevant subtasks.
Hi @Giorgos
Thanks for posting your question!
I suggest selecting the parent level from Sub-task hierarchy in the Issue dimension (see screenshot below)
Then define a new calculated measure with formula below (you can also apply a row filter on this measure for your measure (see screenshot below, where I have also applied the row filter for measure which I have named “Solution” - behind it is the formula pasted below).
CASE
WHEN
[Issue.Sub-task].CurrentHierarchyMember.Level.Name = "Parent"
THEN
[Measures].[Issues created]
WHEN
[Issue.Sub-task].CurrentHierarchyMember.Level.Name = "Sub-task"
THEN
Nonzero(([Issue.Sub-task].CurrentHierarchyMember.Parent,
[Measures].[Issues created]))
END
Best wishes,
Elita from support@eazybi.com
Hi @Elita.Kalane thank you for the suggestion. Tried to create the calculated measure and i get the following error →
Hi @Giorgos
Can you please try the formula below and see if it works for you?
CASE
WHEN
[Issue.Sub-task].CurrentHierarchyMember.Level.Name = "Parent"
THEN
[Measures].[Issues created]
WHEN
[Issue.Sub-task].CurrentHierarchyMember.Level.Name = "Sub-task"
THEN
Val(Nonzero(([Issue.Sub-task].CurrentHierarchyMember.Parent,
[Measures].[Issues created])))
END
Best wishes,
Elita from support@eazybi.com
Hi @Elita.Kalane
The same again
Hi @Giorgos
I’m sorry to hear you are still facing the issue. Could you please share the report definition and send it to support@eazybi.com referring to this community post?
Here is a link to instructions for exporting report definition - Export and import report definitions ?
Best wishes,
Elita