Structure formula: How to get HISTORY of story point values of epics?

Frank June 21, 2023

I need the history of story points of epics in an array to identify the max value. 

- I tried this "history.changes.FILTER($.field = "Story Points")"

- and get this: "Story Points → 130, Story Points → 100, Story Points → 140, Story Points → 100"

- MAX() does not work because of TYPE error.

- My Approach below to get the highest value does not work because the last item in the array has sometimes no value and ends "Story Points → ".

 

If ( issueType = "Epic";
WITH sp_history_array = history.changes.FILTER($.field = "Story Points"):
WITH sorted = SORT(sp_history_array):
WITH max_change = LAST(sorted):
WITH number = REPLACE(max_change; "Story Points →"; ""):

IF number>= StoryPoints: number
ELSE: StoryPoints
)

Any idea?

Thanks

 

2 answers

1 accepted

0 votes
Answer accepted
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 29, 2023

Hello @Frank 

You can display the highest assigned value with a formula like this:
history.changes.filter($.field = "story points").toText.umax()

I hope this helps. If you need further assistance with this or need help with anything else, please contact us directly at our support portal: https://tempo-io.atlassian.net/servicedesk/customer/portal/6/group/1051

Best regards,
Stepan Kholodov
Tempo

Frank June 29, 2023

Thank you Stepan! It works :)

Like Stepan Kholodov _Tempo_ likes this
0 votes
Frank June 30, 2023

Hi @Stepan Kholodov _Tempo_  I have another question: I want to calculate the average velocity with the following approach:

//identify the names of sprints with completion date last 2 month

WITH sprintnames = sprint.FILTER($.completeDate>DATE_SUBTRACT((NOW()), 2, "month")).name:

//sprintnames returns the names of the sprints - that's fine :)

//is there a solution to count the number of sprints in "sprintnames"?

 

Then I tried to filter the issues of these sprints to get the story points:

SUM{item.FILTER($.sprint.name = sprintnames).storypoints} //not working :(

The idea is, to devide the story points by the number of sprints to get the velocity for an automated delivery forecast.

PS: Unfortunately I have no admin rights, so I can't use your suggested tool.

Thanks and best,

Frank

Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 30, 2023

Hello @Frank 

You can get a number of certain Sprints of an issue by using a formula like this:
sprint.FILTER($.completeDate>DATE_SUBTRACT((NOW()), 2, "month")).size()

There is no direct connection between Story Points and Sprint fields so a certain Story Points value(different from the value displayed in the field) can't be extracted through a Sprint name. You can divide the existing Story Points value by the number of Sprints and get some statistical data, but for more detailed information changes in your setup in Jira might be required.

If you need further assistance, please submit a support request at our portal: https://tempo-io.atlassian.net/servicedesk/customer/portal/6/group/1051 and we'll get back to you shortly. You don't need admin rights for accessing it, it's available for everyone and anybody can have an account there.

Best regards,
Stepan Kholodov
Tempo

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events