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 _Tempo_ · Accepted solution]

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

[Stuart Lipinski]

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?

[Stuart Lipinski]

Posted as a reply instead