Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need Help In structure formula for expected epic progress

Tehmina Aslam
Contributor
July 4, 2024

Hi,

 

I have created structure formula that check

  • How many original estimates are within epic example 200
  • The epic field have Start date is July 1, 2024, and Due Date = July 30, 2024. 
  • if means in 30 days 200h to be completed. today is the 4th day from the 30th days 
  • It should calculate in 30 days almost 26.7 hours has to be completed that means 13% it should be completed in 4 days 

 here is the formula works but I want to make it red if the due date < 7, yellow if > 7 ...

 

WITH totalDuration = dueDate - startDate :

WITH daysElapsed = NOW() - startDate :

WITH progress = IF totalDuration > 0 AND NOW() <= dueDate : ROUND((daysElapsed / totalDuration) * 100) ELSE : 0 :

WITH overdueDays = IF NOW() > dueDate : ROUND((NOW() - dueDate) / (1000 * 60 * 60 * 24)) ELSE : 0 :

WITH overdueText = IF NOW() > dueDate : overdueDays CONCAT " days late" ELSE : "" :

IF issueType = "Epic" :

    IF NOW() > dueDate :

        overdueText // Only show overdue text if the due date has passed

    ELSE IF totalDuration > 0 :

        """${progress}%"""

    ELSE :

        """Not Estimated"""

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events