Structure group by on label and same labels not needed

[Els Vercauteren]

I made a structure grouping on labels.

It works perfect but i have multiple labels in the tickets and some labels i do not need in seperate block as the are already in other block (with other label) and creating doubles in structure now. 

Is there a work around ?

f.e. (example made simpler as talking about couple of thousand tickets ;-)) 

- ticket 1 : 2 labels   :  Test and Product1

- ticker 2 : 2 labels   : Development and Product1

In structure i want to see group by block on Test and Development but don't want the block on  Step1

Also knowing i want to keep the elements in the labels and rather difficult to switch to other jira fields

[David Niro · Accepted solution]

Hello @Els Vercauteren ,

David from ALM Works here.

When grouping by labels, you will indeed get duplicate issues if the issue has more than one label.

It sounds like you do not want duplicates.  I will need to know more about your goal and expectations in order to help find a working solution for you.

Could you please describe how you would like to identify which duplicate issues to remove? 

Maybe there are certain labels you don't want groups for? If this is correct, what if an issue has two labels you do want groups for, are duplicates ok in this scenario?

Looking forward to your response!

Best,
David

[Els Vercauteren]

Hi @David Niro 

Correct that i don't want to see specific labels (fixed list of labels). As in my example i don't want to see the group of PRODUCT 1 (see below)

Even with the exclusion duplicates can be there but no issue if it is the correct (needed) label

OVerall i want to exclude specific labels without losing the tickets which have other labels besides the ones i want to exclude. Because this is what is happening now. By excluding a label in the structure the ticket completely disappears even though it has other labels where i want to view the stories.

f.e. (example made simpler as talking about couple of thousand tickets ;-)) 

- ticket 1 : 2 labels   :  Test and Product1

- ticker 2 : 2 labels   : Development and Product1

What i want to see in structure is block of TEST and Development

TEST

       Ticket1

Development

       Ticket2

PRoduct1

       Ticket1

       Ticket2

[David Niro]

Hello @Els Vercauteren ,

We will need to know if you are on a Cloud or On-Prem instance of Jira for the next step.  When looking at a Structure, do you see a button called "Automation" or one called "Show Generators"?

If you see "Show Generators", you are on Cloud and the solution provided is not yet available.  Unfortunately there is no other workaround.

If you see "Automation", you are On-Prem and you we can make use of Group by Attribute and set the attribute to Formula. (note:  this requires Structure 7.4 or higher)

Please try this formula:

labels.FILTER($ != "Product1")

This will create a sub-array of the labels and exclude "Product1" leaving just the labels you want.

Please give it a try and let me know if it helps.

Best Regards,
David Niro
www.almworks.com

[Els Vercauteren]

I see automation, i will try to test asap 

[Els Vercauteren]

Hello i tried but got issue.

Label i don't need is in reality "fnd_m2c"

What i did

- made new column and added formula

I probably do something wrong 

[David Niro]

Hello @Els Vercauteren ,

Could you please check the version of Structure you are currently using?  The proposed solution works in 7.0 and above.

To find the version, please click on the info button, bottom right corner of structure.

Best,
David

[Stepan Kholodov _Tempo_]

Hello @Samantha Riccio 

The formula then should look like this:
labels.FILTER($ != "Product1" and $ != "Product2")

You can exclude more labels in the same fashion.

Best regards,
Stepan Kholodov
Tempo

[Samantha Riccio]

@David Niro - How would you write this is if you need to exclude multiple labels? 

I've tried 

labels.FILTER($ != "Product1";"Product2")

and

labels.FILTER($ != "Product1") AND ($ != "Product2") 

Whats the correct way to do this?