Jira Structure - Is it possible to calculate a % based on the total Story Points in that column?

[Bernie Wu]

Hello community,

I'd like to calculate the % of a grouping based on the total story points for that fix version.

Fake Example:

Group 1
- 10 SP

Group 2
- 20 SP

Group 3
- 20 SP

I can create a formula column that sums up the total story points at a project level (in this example = 50 SP), but I can't seem to figure out the formula for calculating % per Group X.

Using the example above, I'd like my Structure to look something like:

Project Level Group 100%
--> Group 1              20%
--> Group 2              40%
--> Group 3              40%

Is this possible?

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Bernie Wu 

Ii is possible to do but the formula should be specifically tailored to your structure. For example, if you only have 2 hierarchy levels: Version-based group -> Story then you can try a formula like this:

if !issuetype and count#children{issuetype}>0: sum{storypoints}/parent{sum{storypoints}}

You can set the column's Format as Percentage.

I hope this helps. If you need further assistance, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Bernie Wu]

Hi @Stepan Kholodov _Tempo_ ,

Thank you. This was very useful and has pointed me in the right direction. I was hoping that push would have gotten me to my specific problem, but I am getting stuck with how to only calculate based on certain criteria of the issues.

So my specific data set is grouped by a custom field. Within the custom field are a bunch of issues that have different fix versions. I'm looking to be able to do a similar calculation that you had above, but filtered on a fix version.

Updated example (sorry, I can't give you anything real):

Group 1
- Issue 1, fixversion A, 10 SP
- Issue 2, fixversion A, 10 SP
- Issue 3, fixversion B, 20 SP

Group 2
- Issue 1, fixversion A, 10 SP
- Issue 2, fixversion A, 10 SP
- Issue 3, fixversion C, 10 SP

Group 3
- Issue1, fixversion A, 10 SP
- Issue 2, fixversion B, 10 SP
- Issue 3, fixversion C, 10 SP

Output:

Summary                    FixVersion A     Fixversion B    Fixversion C
Project Level Group   100%                 100%             100%
--> Group 1                40%                   67%               0%
--> Group 2                40%                   0%                 50%
--> Group 3                20%                   33%               50%

I tried to add an additional if statement to check fixversions to your formula above, but since we're looking for non-issues, I think my second if statement is basically failing every time. Hopefully there's a simple solution to try and do what I'm doing above.

Ideally, this could still be done in 1 column, but if I have to do it in 2, I think I could adjust the columns so the temp column isn't a focus.

Thanks,
Bernie

[Bernie Wu]

I think I was able to figure it out. I'm not super familiar with EXPR so there's probably some knowledge deficit I had, which made it harder to figure out.

This is what ended up working for me:

if (!issuetype and count#children{issuetype}>0,
  sum{fixversion = A && storypoints}/parent{sum{fixversion = A && storypoints}},

  if (Summary = "Project Level Group", 
    sum{fixversion = A && storypoints}/sum{fixversion = A && storypoints},

    storypoints/parent{SUM{fixverion = A && storypoints}}
  )
)

The 2nd IF statement is a bit dumb cause it just divides the same number, which would of course get us 100%. But I wasn't sure if there was another way to do it.

@Stepan Kholodov _Tempo_ - The first "hint" was the right direction and a little more experimenting and learning some more syntax and I was able to get what I needed.

[Danut M _StonikByte_]

Hi @Bernie Wu,

Not sure of this is possible in Jira Structure,  but you can calculate such numbers and  display them on your dashboard by using the Advanced Issue Filter Formula gadget offered by our Great Gadgets app. 

Be aware that this app offers many other gadgets that you can find useful.

I hope this helps.

Danut.

[Asha Goyal]

Hello @Bernie Wu 

With the help of marketplace plugin you can try grouping. I would recommend a free addon that will give you lots of options to group.

Status Time Reports Free - Time in Status | Atlassian Marketplace

Kindly Accept the ans if this helps.

Thanks

Asha