I have a Jira structure that is returning Epic's under a certain condition which are extended to show issues belonging to Epics (Stories).
Via a formula column i am trying to sum the number of stories completed within a certain time period and sum that number at the Epic level;
IF issuetype = "Epic":
SUM{IF issuetype = "Story" AND (resolved>08/05/2024 ) : 1}
I have also tried
IF issuetype = "Epic":
SUM{IF issuetype = "Story" AND (resolutiondate>08/05/2024) : 1}
While completed stories are being totalled correctly that date is being ignored, is the date format i am using incorrect, is there a better way?......
Hello @Crads
The Formula column processes dates as timestamps, so a custom date should be defined as one as well. To define a date, you can use the date() function like this:
if resolved > date("2024-05-08"): 1
I hope this helps. If you need further assistance or if you have more questions about Structure, please reach out to us directly at our support portal.
Best regards,
Stepan
Tempo (the Structure app vendor)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.