Use a filter for Parent Ticket select

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 →
image

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