How to split parent and child option into two different columns of cascade custom field?

[Suchithra]

Hi Team,

Need separate calculated measure for parent - cascade and child - cascade.
How can we do this? Facing some formula issues in writing user defined measure
Thanks in advance

Regards,
Suchithra S

[nauris.malitis]

Hi @Suchithra

If this is a standard Jira “Select List (cascading)” field, then after importing it as a dimension, you should see that it has a hierarchy with levels “First” and “Second”.

A formula like this will return the level name for each of the rows:

[Example cascading field].CurrentHierarchyMember.Level.Name

Use it together with a CASE statement to return one formula for the Parent level and another for the Child level:

CASE WHEN
  [Example cascading field].CurrentHierarchyMember.Level.Name = "First"
THEN
  "Parent formula"
ELSE
  "Child formula"
END

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris

[Suchithra]

Hi Nauris,

Thank you much for your reply.
Let consider I have cascade custom filed with the name “Implementer BU and Sub BU”. Here BU will be the first and Sub BU will be the second.
I need separate column for BU and separate column for Sub BU not the rows.
Can you please suggest how can I achieve this? I need any clarifications please let me know.

Regards,
Suchithra S

[nauris.malitis]

Hi @Suchithra

In Jira, when you assign the cascading values for the issues, you need to specify both the BU and Sub BU value for each issue, right?

With this in mind, how you would like the values to be displayed in the report?
You can move the cascading dimension to the Columns and then expand the BU members to see the Sub BU members within them like this:

If this is not the intended use, could you please give some examples of issues with their BU and Sub BU values and how they should be counted in the report?

Thanks!
​Best regards,
​Nauris