Filtering out groups on Structure

[Kelsey Mitchell]

I have a Jira Structure that has folders, and under each folder the issues are grouped by a custom label field. This field can have multiple entries, but I only want the ones that match the filtered folder to show.

For example:

Jira issue XYZ-1 has label A-1 and B-1 and issue XYZ-2 has label A-1 and A-2

What shows now  for the custom label groups:

(folder) A

->(custom label group) A-1

->->XYZ-1

->->XYZ-2

->(custom label group) A-2

->->XYZ-2

-> (custom label group) B-1 

->->XYZ-1


(folder) B

->(custom label group) A-1

->->XYZ-1

-> (custom label group) B-1 

->->XYZ-1

How I want the groups to display under the folders

(folder) A

->(custom label group) A-1

->->XYZ-1

->->XYZ-2

->(custom label group) A-2

->->XYZ-2


(folder) B

-> (custom label group) B-1 

->->XYZ-1

[Egor Tasa [ALM Works]]

Hi Kelsey,

In this particular scenario it is possible to use formulas for additional grouping. So add grouping by formula IF(SEARCH("B", summary), "B", SEARCH("A", summary), "A")

For that, group by Text Attribute>Formula, then enter the above formula. You will also need to check "Consider other groups" box, and after the generator is created make sure it is one row below the grouping by label generator (you can use down or up arrow buttons above the structure to adjust the position of generator).

If your label names are more complex, you'd have to search for the values, but note that if one value contains another the search would have to be more complex.

Regards,
Egor Tasa

ALM Works

[Kelsey Mitchell]

That just seems to group them to how I've got the folders set up. I still have the "B-#" label groups under the "A" folder or the "A" formula grouping. How do I remove those from that group?

Here's my automation rows for the Structure if that helps:

Group by Formula (the formula given above)

Group by custom label (to get the A-1, A-2 groupings)

Insert Issues

[Kelsey Mitchell]

This thread seems like it may be helpful. But I don't know how do do the " Filter transformation that allows removing certain created groups and all issues in them" that Sepan calls out.

https://community.atlassian.com/t5/Jira-questions/Filter-Structure-by-values-in-a-Formula-column/qaq-p/1390244

[Egor Tasa [ALM Works]]

Hi Kelsey,

- Group by Formula (the formula given above)

- Group by custom label (to get the A-1, A-2 groupings)

- Insert Issues

You'll need to change order of Groupers as I described earlier: "make sure it is one row below the grouping by label generator (you can use down or up arrow buttons above the structure to adjust the position of generator)"

As for Stepan's comment you can add Filter (text) transformation (containing just B) at level 1 (level setting of the transformation) to keep only folder B and its children.

Regards,
Egor

[Kelsey Mitchell]

I'm sorry, rearranging the order just puts the formula groups under the label groups. It doesn't remove the label groups of "B" from "A" or the label groups of "A" from "B".

As for the Filter(text) I'm confused. I would need to put a filter on each of the parent formula groups on that label 1?

[Egor Tasa [ALM Works]]

Hi Kelsey,

Did you check "Consider other groups" under formula grouper?

For the filter I assumed you want to remove "B" or "A" rather than individual issues or their labels.

Regards,
Egor

[Kelsey Mitchell]

When I have the order as:

- Group by custom label

- Group by Formula

- Insert issues

And click "Consider other groups" on the formula grouper it just puts everything into a No value folder.

Yes, I want to remove "B-#" custom label groups out of the larger group. 

So when everything is collapsed, I'll see

>A

>B

>C

etc

Then when expanded:

A 

-> A-1 (custom label value)

->->XYZ-1

->->XYZ-2

->A-2

->-> XYZ-2

B

->B-1

->->XYZ-1

What is happening right now, is that under the "A" parent group, there's a "B-2" custom field grouping b/c XYZ-1 has both "A-1" and "B-1" values in the custom label field.

[Egor Tasa [ALM Works]]

We'll need to troubleshoot this issue and community post is not very convenient for that. Can you create a ticket with us in support@almworks.com ?

Regards,
Egor