Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Structure formulas for 'spent time in status' column

Hello, I would like to create columns where I can show how much time was logged on an issue in different statuses (I would made as many columns as many statuses I would like to display) Is it possible to use formulas for this? I only could set columns which shows the time the issue spent in the statuses. I can't figure it out how should I set the formulas. Can you help me?

Thank you

3 answers

Hello @Hajnalka Farkas 

You can try Time in Status for Jira Cloud add-on, which shows how much time an issue has been spending in each status.  There are different columns for each status. 

You don't need any formulas or long configs. In a few clicks, you'll get the necessary data!

Also, you'll get data both in Graphs and Chart view.

I hope you find this helpful.

Best regards, Mariana.

total.png

Hi @Mariana_Pryshliak_Saasjet

Thank you for the reply. However we wanted to solve it within the structure plugin, but we will look into the plugin.

KR, Hajnalka

Hello @Hajnalka Farkas , Alessandro from ALM Works here.

The easiest way to sum the Duration of an Item, in one or more status using Structure, is through the "Time in Status..." column.

You can select Duration from one or a Sum of different Statuses.

This can also be achieved by using the "Formula..." option when adding new Columns as you mentioned. You can then set a "timeInStatus" variable in the formula field, save the formula and then update its definitions by:

  1. Click the "! timeInStatus" below the Formula field;
  2. Select "Time in Status" on the attributes DropDown (when you first select the drop-down, it works as a search field as well, so you can start Typing to make it easier to find the attribute);
  3. Once 'Time in Status' is selected, click on the Cog icon to the right of the attribute field to select which Status you would like to sum as a total.
    I.E.: You can select just "In Progress" or "In Progress" and "Done" to see the total time across both statuses.
  4. Change the Format field to "Duration" to make Structure calculate the formula as total of hours tracked.
  5. You can then customize other properties as you like, such as Sum a total of Hours based on subitems, if you want to show the total hours worked in all Stories under an epic or select "Work Time" in case your project hours are tracked according to Jira's "work hours per day" settings.
  6. Once done, just click outside the Column configuration panel and you should be already seeing the Duration of the selected status.

Please let me know if this helps! I look forward to hearing from you.

Warmest regards,
Alessandro C.
ALM Works.

Hello @Alessandro C_ _ALM Works_

Thank you for the reply. We will look and test to see if that’s what we’re looking for.

KR, Hajnalka

Hi @Alessandro C_ _ALM Works_ -  I am looking to add a single column to my Structure board which should tell me the time in the status the issue is currently in. How can I achieve this?

Thanks

Like Alp Erguney likes this

Hello @Manali Butey If you are on Jira Server/Data Center, you can see the time spent in any status using a special Time In Status Column . Just add this column, select the status you're interested in and Structure will show the time spent in this status.

Best regards,
Daria

Hi @Daria_Baltiyskaya_ALM_Works_ - I have 10 statuses, and at a given point in time the issue is in one of the theses status. Instead of making a column each for the time in status I would like one column only that gives me the time in status for the status the issue is currently in instead of giving me a  Σ time in all status the issue has been in. 

Happy to clarify further if required.
Thanks.

Hello @Manali Butey ,

David from ALM Works here.

There is a way that we can create a column that shows Time in Current Status. This can be accomplished through the use of a Formula Column.

There is some time commitment in getting it set up though. We have to create a Time in Status Column for each of the statuses used in the workflow (don't worry, we will remove these later :)).  From there, we will use these Columns as Variables in our Formula.

Step 1:
Create a Time in Status column for each of the statuses the issues could potentially be in.

You will want to name each of these something unique (this will help later when we map it as a variable)
 

Step 2:
Create the Formula Column

  • Use the formula template: IF(Condition1; Result1; Condition2; Result2; ...; DefaultOpt)
    If(status="open";timeinopen;status="reopened";timeinreoopen;status="to do";timeintodo;status="closed";timeinclosed)
  • Map each Result to the corresponding column as its variable assignment
  • Set the Format from General (default) to Duration

Step 3:
House Keeping

  • Because all of your Time in Status Columns are now Variables in your Formula Column, you can safely remove them from your structure
  • Save your view

Please let me know if this helps!

Best Regards,
David Niro
www.almworks.com

0 votes
Rahul_RVS_Support Marketplace Partner Sep 14, 2020

Hi @Hajnalka Farkas 

We have built an addon specifically for this need, as there is no easy way to extract this information out of the box.

You can try Issue Tracker for Jira 

It will provide you below charts on the issue screen itself.

Thanks

Status Transition Graph.PNG

Status Transition_new.PNG

Hello @Rahul_RVS_Support ,

Thanks for posting the information, great to see the alternative option, and I have a quick ask for you for a follow-up.

Please review the partner guidelines here, and make sure to update your username according to your relationship as a vendor of the tool, noting:

Identify yourself as a partner: Make sure the user is aware you are affiliated with a partner company; for example, by placing the name of your company in your user name in {curly brackets} or -dashes- (note that regular brackets no longer work and have been automatically converted to dashes). If you are mentioning your own products or services, make sure you include wording to make it clear that you are affiliated with the company providing those products or services.

Regards,
Earl

Rahul_RVS_Support Marketplace Partner Oct 12, 2020

Thanks @Earl McCutcheon for notifying me. I have updated my username accordingly

Like Earl McCutcheon likes this

Hello @Rahul_RVS_Support 

Thank you for the answear. However we wanted to solve it within the structure plugin

kr:Hajnalka

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

454 views 19 23
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you