Calculated field based on part of the labels on an issue

[Matthew]

Hello! 

For enhancement requests and bug reports we use the label field to add the customer ID and size of the customer for tracking the requests or reports. For example, a huge customer with the customer ID of XYZ would have the label XYZ-H added to the ticket.

Now, I'd like to be able to create a calculated field on tickets that would review the labels and return a count of the number of labels based on the size group, which will always be the last letter in the tag and always follow a dash. We have five size groups, Tiny, Small, Mid., Big, and Huge. Is something like this possible in Jira Cloud?

[Tomislav Tobijas _Koios_ · Accepted solution]

Hi @Matthew ,

Can you maybe share some details of how many different customers you have? I'm wondering why the size needs to be on the same label as the customer ID? Couldn't you separate those and have, for example, XYZ and Huge as two different labels. Also, cannot the size be a separate custom field that has those fixed group size options as these are always 'fixed'? I believe this approach would make the solution much more easier (and scalable).

As for the calculated field - do you need this field to be visible on each ticket; and can the ticket contain different customers and different group sizes simultaneously? Or, do you need one field (somewhere) which would make calculations based on multiple Jira tickets?

I was thinking of maybe using some kind of automation combination that would include Lookup table but I guess some more info (process explanation) is needed here.

Cheers,
Tobi

[Matthew]

Hi Tobi,

We have a little over 2,000 customers and theoretically all 2,000 could be on the same ticket if they all requested that feature, so sperating the size from the customer ID won't work. The end goal is to have a field for each size group on every ticket that displays the number of customers in that size group with a label on that ticket. The field name would be the size group and the field would just be the sum of the number of customers in the size group in the labels on the ticket.

If there's a better way for us to track vs labels I'm also open to that. Our support team uses Zendesk so Jira organizations aren't currently used.

[Tomislav Tobijas _Koios_]

@Matthew got it. I was thinking in the direction of filtering Labels with smart values (labels is actually a list) where you'd filter out only labels containing "-M" or "-H" and basically count the size of that list and store that value in this size number field you'd probably have for each group size.

However, I didn't play that much with filtering and additional conditioning within smart values so I would probably need to give it a couple of tries/tests to get it to work.

I'd suggest checking the following article/discussion: Filtering smart value lists, or the following question: Jira Automation - Smart Value to Extract Label from Issue 
If I find the time in the next couple of days I can try to build something like that, but no promises.

@Bill Sheboy might have built something similar in the past and might have some tips & tricks based on your requirements.

Cheers,
Tobi

[Bill Sheboy]

Hi @Matthew -- Welcome to the Atlassian Community!

Adding to the suggestions from @Tomislav Tobijas _Koios_ ...

You could use smart value, list filtering and a math expression, or try a match() function to count the items with size.  For example to count the ones ending in -M with a regular expression and match():

{{issue.labels.match("(.*\-M)").size}}

Kind regards,
Bill

[Matthew]

Thank you @Tomislav Tobijas _Koios_  & @Bill Sheboy  this worked like a charm!

[Matthew]

.