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

Stuart Lipinski

Hi

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?

Cheers!

Stepan Kholodov

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
Tempo