SPI Calculation with Automation

Tatiana María Valle Reyes

Hi Team! I'm Trying to create an automation rule to calculate SPI, with a corporate Jira version without any extra plug-ins, so far, this is my rule:

 

- When: Sprint Completed

- Then: look up issues project = "ANC" AND Sprint in closedSprints

- And: Add value to the audit log {{lookupIssues.Story Points.sum}}

- And: Add value to the audit log project = "ANC" AND Sprint in closedSprints() AND status = Done

- And: Create variable {{PV}}

- And: look up issues project = "ANC" AND Sprint in closedSprints() AND status = Done

- And: Add value to the audit log {{lookupIssues.Story Points.Done}}

 

- And: Create variable {{EV}}

- And: Create variable {{SPI}} {{#=}} {{lookupIssues.Story Points.Done}} / {{lookupIssues.Story Points.sum}} {{/}}

- And: Send Mail

Trudy P Claspill

Hello @Tatiana María Valle Reyes 

Welcome to the Atlassian community.

What is your definition of the acronym "SPI"?

Can you provide screen images that show the actual rule and the details of each step?

What is the output in the rule audit log when this rule executes? Can you provide screen images that show that also, with every entry within the log for that one execution expanded?

Is this rule giving you the output you expect? If it is not, in what way is it not matching your expectations?

In your text you indicate that you create three separate variables; PV, EV, and SPI. But you don't tell us how you are setting values for those variables.

What value do you expect to get for {{lookupIssues.Story Points.Done}} ? I don't believe that this is going to give you any value as it is not valid syntax.

Are you expecting that your Lookup Issues actions are going to retrieve the issues just for the most recently completed sprint? If so, that will not be the case based on the JQL you have shown.