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

[Frank]

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

[Stepan Kholodov _Tempo_ · Accepted solution]

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]

Thank you Stepan! It works :)

[Frank]

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_]

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