Need help with a Structure formula expr to sum unique issuelinks types

Question

For a given issue, I want a structure formula column to display the total for each of the different issuelinks.type for that issue. Basically the equivalent of a UNIQUE_COUNT.

I can use  UNIQUE(issuelinks.type) to see the different types. Now I need a sum of each. I've tried various ways with SIZE() but can't figure it out.

Chris Lee_30qssd · Answer

This is what I came up with and it works (hooray):

WITH aa2 = (issueLinks.type.inward).UNIQUE():
WITH seq1 = SEQUENCE(0, aa2.SIZE()):
WITH totaltype(arr, idx) = GET(arr, idx) CONCAT ": " CONCAT SIZE(issuelinks.FILTER($.type.inward = GET(arr, idx))):
seq1.MAP(totaltype(aa2, $)) CONCAT ", "

Chris Lee_30qssd · Answer

Thanks. I had this brute force method in place but was hoping for something more elegant and dynamic where I could pull all types into an array, iterate over that array, and pull the sums/counts of total issues of each type.

Stepan Kholodov · Answer

Hello @Chris Lee

You can try a formula like this:

with abc = issuelinks.filter($.type="blocks").size():
with def = issuelinks.filter($.type="implements").size():
array(abc,def)

At the top, you would need to define all link types that you want to count, and the formula will show if an issue have any of them.

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

Best regards,
Stepan
Tempo (the Structure app vendor)