Group by in Jira structure from lower element but shown at top level

[marc_olivier]

I have the following structure

• Initiative (with a field "Team", with multiple text values, Team 1, Team 2)
  • Epic
    • Story (with a field "Device Type" values Desktop and Mobile)

In my Jira structure, I have the following default "view"

• Team 1
  • Initiative-1
    • Epic-1
      • Story-1
      • Story-3
  • Initiative-2
    • Epic-2
      • Story-2
      • Story-4
• Team 2
  • Initiative-3
    • Epic-3
      • Story-5

I want the structure user to apply a transformation that would give something like

• Mobile
  • Team 1
    • Initiative-1
      • Epic-1
        • Story-1
  • Team 2
    • Initiative-3
      • Epic-3
        • Story-5

• Desktop
  
  • Team 1
    • Initiative-1
      • Epic-1
        • Story-3
    • Initiative-2
      • Epic-2
        • Story-2
        • Story-4

I tried the Quick Transformation Group-by on the field "Device type" (and using level 3), but it gives me something that does not suit my needs.

• Team 1
  • Initiative-1
    • Epic-1
      • Mobile
        • Story-1
      • Desktop
        • Story-3
  • Initiative-2
    • Epic-2
      • Desktop
        • Story-2
        • Story-4
• Team 2
  • Initiative-3
    • Epic-3
      • Mobile
        • Story-5

Is there a way?

Thank youü

[Stepan Kholodov _Tempo_]

Hello @marc_olivier 

Groupers can't skip levels of the hierarchy in the structure, i.e. you can only show groups above issues with values that groups are based on. To achieve what you need, you would need to group Initiatives after passing their Stories' values to them first. You can do it using the Attribute grouper as a transformation with a formula like this:

if issuetype = "initiative" : max{if issuetype = "story": devicetype}

You might need to adjust the formula in cases when there are multiple values in the field.

I hope this helps. If you need further assistance here, or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[marc_olivier]

Thanks

I am trying to understand what you mean by "passing their Stories' values to them first".
Would you mind clarifying?

For instance, in the example above, Initiative-1 has two stories in its hierarchy with different Device Type.

[Stepan Kholodov _Tempo_]

You have a complicated setup. You can try adding a Formula column with the formula I shared and see what happens before using it in the attribute grouper; it might help you to understand how it works better.

Since stories have different values, then after grouping, your Initiatives (and all of their sub-issues) will inevitably be duplicated. Technically, each Initiative will get as many values as the number of unique values each of its Stories has. So, it will be duplicated to appear in every values-based group, and the rest of the hierarchy will follow each duplicate.

The grouping can be done with this formula:

if issuetype = "initiative": split(array{if issuetype = "story": devicetype}, ",")

If you have further questions about this, please submit a support request.

Best regards,
Stepan