Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Structure Formula Question - Sum Feature Points based on historical labels

Wilhelm Schmelz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 3, 2024

We are currently using Structure (Data Center, v9.2.1) and I need help how to calculate the sum of feature points at a given point in time.
I like to calculate the sum of feature points after PI planning event given by a date.

Each feature which is planned in the upcoming PI gets a label to indicate in which sprint we plan to finish the feature. E.g. Label: 24A_1

We change this labels during the PI execution as well. New features might come in and have to be planned, or the initial plan is shifted and a new label is added.

Therefore, to know the initial plan, I would need to know which features had the specific labels at a given point in time. E.g. I have to find all features which had the label 24A_1 on 01.02.2024.

Then I can use the result of the query to calculate the sum of the feature points.

How can I do that?

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
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.
April 5, 2024

In case anybody else finds this post and have the same question - Wilhelm reached out to us directly via our support portal.

The mentioned formula can look like this:

if historical_value(this, "labels", datetime("15/Mar/24 6:24 PM")) = "24A_1": 1

the 'Sum over sub-items' option should be enabled in the column's configuration. 

The formula of this type can be used for other fields as well.
Note: the format of date & time differs on each instance, so that part of the formula might require some tuning for it to produce right results.

Best regards,
Stepan
Tempo (the Structure app vendor)

TAGS
AUG Leaders

Atlassian Community Events