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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Structure - show time elapsed in project as well as progress through stories


Our company is starting to use Structure to manage a large cross-team project. Multiple teams, multiple Jira Projects, and a mix of Kanban and Scrum (another question incoming about that!).

We've made some progress in getting a Structure set up, but one thing that would be useful would be to be able to set a start date and a target end date for the project and be able to see percentage of time elapsed. This would enable us to use the Progress as measured in the percentage of tickets/stories/points that we have at the moment, and compare it with time passed. For example, we might see that we've done 67% of stories, however 80% of possible time has already passed, and we know that (potentially...) we're pretty behind where we should be.

Has anyone done this already that could share any solutions?


2 answers

1 accepted

0 votes
Answer accepted
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.
Oct 02, 2023

Hello @Stuart Lipinski 

You can calculate progress using the Formula column and apply your own logic to it. For example, you can try the following approach:

1. Place all issues in the structure in a folder. Create a new Structure Item and either drag and drop selected issues in it or place the Insert generator there(if you're using the generator for adding issues to the structure automatically). The folder will act as the top-level item where the progress values will be aggregated and displayed.

2. Add the Formula column with a formula like this:

with targetstart = date("2023-01-01"):
with targetend = date("2023-12-31"):

with elapsed = round(days_between(targetstart, today()) / days_between(targetstart, targetend)*100):
with completed = round(sum{if resolved: "1"}/count{issuetype}*100):

if !issuetype: concat(elapsed, " | ", completed)

where the targetstart & targetend variables are the dates of the project.

The formula will:
- calculate the elapsed time based on the Target Start & Target End dates and today's date;
- calculate the percentage of the completed issues(based on their Resolution field) compared to the overall number of issues;
- display both parameters together.

You can name the column to reflect its content, if needed. For example: "Time Elapsed | Issues Completed" or something similar, to make it easier to understand the displayed values. You can also apply a different logic for counting completed issues and add more visibility through adding color, for example.

I hope this helps. If you need further assistance with your use-case, please reach out to us directly through our support portal.

Best regards,
Stepan Kholodov

Hi Stepan

Thanks for this great suggestion, it really helped lead me in to some of the things that I can do with the formula column!

One thing that I can't figure out how to do is to use the same value that is shown in the Progress column rather than just the percentage resolved as in your example. We have a progress column and that uses Status to calculate the overall percentage and we have a list of the various statuses that the teams use, along with the percentage done that we consider each status means. 

I can use "progress" in a variable within my formula column, however it uses the default set of statuses an percentages, rather than the ones that I'm using in the Progress column in the same structure. 

Is there any way of using the same status/percentage combinations when I pull that in to the formula column rather than having to copy them manually across?

Posted as a reply instead

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events