Structure - Sum Story points for the specific D DAY

[agnes BOURLON]

Hi

I want to sum the storypoints of the tasks and US included in the EPICs on a specific D DAY on a structure column

====

First I started with the current DAY :

SUM#children{storypoints}

====

After I used the history possibilty to filter the changes made on the story points

SUM#Children{
history.changes.filter($.field = "story points" and $.changegroup.timestamp > DATETIME("2023-07-01 00:00")).toText.unmin()
} 

====

I saw that, if there is no change, then any story point will be added.  So I changed the script to add the current story points with the ELSE condition

SUM#Children{
IF history.changes.filter($.field = "story points" and $.changegroup.timestamp > DATETIME("2023-07-01 00:00")).toText.size()>0:history.changes.filter($.field = "story points" and $.changegroup.timestamp > DATETIME("2023-07-01 00:00")).toText.umin()
ELSE :storypoints
} 

CONCLUSION

It works pretty well except that I would like to have the story points on the D DAY  2023-07-01, not the 1st value changed after this date.... I am very close in the solution, but I didn't met it yet

Could you help me please ?

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @agnes BOURLON 

if you simply need to see what Story Points value issues had on a specific day, you can display it with a formula like this:

historical_value(this, "storypoints", datetime("15/May/18 6:24 PM"))

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)

[agnes BOURLON]

Many thanks @Stepan Kholodov _Tempo_ 

Yes that I was needed and it works ! I don't know where to find documentation on this point. Google doesn't provide a lot of information on this feature

I tried to do the same for checking  the status of my EPICs on a specific DATE -> it is OK as well by using this script

historical_value(this, "status",datetime("01/07/23 0:00 PM"))

For sharing information for people having this kind of problematic, here find  a valid request to retrieve the story points of a D-DAY from the EPIC or the SUM of the US or Tasks included, depending on the status of the EPIC on the D-DAY (we count the story point of the US/task when the status EPIC  is IN PROGRESS of DONE)

D-DAY = 01/07/23 0:00 PM on my sample

if(type=EPIC, if (historical_value(this, "status",datetime("01/07/23 0:00 PM")) ="IN PROGRESS" OR historical_value(this, "status",datetime("01/07/23 0:00 PM")) ="DONE",SUM#children{historical_value(this, "storypoints",datetime("01/07/23 0:00 PM"))},historical_value(this, "storypoints",datetime("01/07/23 0:00 PM"))),historical_value(this, "storypoints",datetime("01/07/23 0:00 PM")))

 @Stepan Kholodov _Tempo_ 

Last question : is it possible to use user variable on a formula used in a structure to have a code easier to understand ? For sample var = historical_value(this, "status",datetime("01/07/23 0:00 PM") and after use this variable on the IF()