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

time in status - report

HI 

 

I have a base version of JIRA nextgen cloud version - i am trying to report "time in status" of all my cards in the kanban board - is this possible at all ?

 

some basis reporting we need .. not sure if it is available.. let me know 

 

Thanks

Uma 

4 answers

3 accepted

Hello @Uma Sanjeevi 

You can try Time in Status for Jira Cloud. This add-on generates a report on how long an issue has been staying in each status (Testing, In progress, etc). Additionally, you'll get a few reports that show assignee time, status entry dates, the average time in status, and total time reports. 

You can view data as a Graph or Charts view. 

If you have any additional questions, I'm here to help you

Best regards, Mariana.

tiss3.png

let me try it out first before i accept the answer- will do it sometime this week. 

HI - can I setup which status i would like to report on at all ? there are some status where it is not required to be reported on... is this possible ?

Hello

Can you precise in more details what do you want to do?

If you want to turn off (or turn on) statuses to(or out of) a report, you can do it in Column manager menu easily.

Hi Mariana

 

One question - when i export the data to excel - does it only exports the data for the filter we have as in date ranges - "Created" for xx dates or it covers all the 3 drop down for the date ranges (Created, Updated and Resolved)?

 

if I need all 3 status do i export 3 report and merge them ? i am just thinking to get a complete picture of how long a feature as been in the status for - by driving from "Created" date is good enought to get the full time slice or not ?

 

Please reply back by today if you can.. thanks 

Hi @Uma Sanjeevi 

If you need all 3 date statuses (Created, Updated, and Resolved), just select any date option. And the report will include all issues selected by other filters you select before (without time (date) limits).

In case you need more help, for a quick response please contact our customer success team at support@saasjet.com

Best Regards

Zoryana

Hello-

Is there a way to send a automated email from Time in Status filter that I can get on a daily basis.

 

Thansks

Siva

1 vote
Answer accepted
Bloompeak Support Marketplace Partner Sep 24, 2020

Hi @Uma Sanjeevi ,

Unfortunately, the report you are looking for is not built-in inside Jira.

Our team at Bloompeak developed Status Time app for this exact need. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try. Hope it helps.

Screen Shot 2020-09-21 at 17.45.22.png

this is an plug-in we have to purchase I suppose... an extra plug-in. not part of the base features.. is this correct? kindly confirm. 

Bloompeak Support Marketplace Partner Sep 27, 2020

Hi @Uma Sanjeevi ,

Yes it is a plugin that must be purchased. But, as in all other marketplace apps, there is 1 month trial period without any payment.

I am getting the access to the one mth trail period today to try this out.. thanks. 

Like Bloompeak Support likes this

@Uma Sanjeevi, Here is the marketplace link for the app.

https://marketplace.atlassian.com/1221826

I will appreciate if you accept my answer.

Bloompeak Support Marketplace Partner Sep 27, 2020

@Uma Sanjeevi,

Yes, it is possible. You can define which status you would like to report on. See the below screenshot on how to do it.

Screen Shot 2020-09-28 at 08.22.37.png

 

By the way, there is a tree structure as below in community answers and you replied to under other answers. Because of it, initially I missed your question.

-Your question
|__Answers1
|___answer1 related conversation
|___...
|_Answer2
|___answer2 related conversation
|___...

@Bloompeak Support , this looks like a Jira filter, but I do not see the items you display in step 2 and step 3.  Do you have additional plugins in stalled to access this info?

Bloompeak Support Marketplace Partner Oct 02, 2020

Hi @Marianne Miller ,

Yes, it requires additional plugin. It is the report page of Status Time plugin. You can see it action in the online demo.

Like Marianne Miller likes this
0 votes
Answer accepted

For a ready built solution that offers great fexibility and details, our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee as well as entry/exit dates for all statuses. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype). You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time or Lead Time.

status_duration.pngstatus_date.png

 

status_date.png

 

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

The app has Custom calendar support which means you can get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar in most cases shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can see this using Time in Status by OBSS.)

Using Time in Status you can:

  • See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
  • Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
  • Export your data as XLS, XLSX or CSV.
  • Access data via REST API.
  • Visualize data with various chart types.

https://marketplace.atlassian.com/1211756

EmreT

this view can be improved to what and how it is used...  it can accommodate the following suggestion for better usability and user friendly perspective 

 

1. Order the columns to the kanban / sprint board view of the project

2. ensure only the project cards are visible and not all cards across all projects

3. have a % data view under the format tab - because the % view is better stats as compared to no of days and etc.. you can actually use the % view to really understand the flow across the different size of work

4. when cards are migrated from one board to another - use the status in the current board only.. and not map the whole lot of status the card has gone thru - have it relate to the current project view.

 

5. the export option - order the data to the JIRA view and the data is exported as numeric data type to excel and not just a text data type .. one less step to do manually to convert the columns to number

 

I am currently using this plug-in lots and want this plug-in to be more user friendly as well. Esp when exec and top management are looking at it as well. currently whatever i setup is only visible to me .. the settings are not saved at the project level ( I really hope we can able project level settings ).

 

Thanks

 

Uma Sanjeevi  

Hello @Uma Sanjeevi ,

Thank you very much for the feedback. It is very very important for us.

Since we cannot get your direct contact information from here, can you send these items as an email to plugin@obss.com.tr so we can start a conversation with you to get more details.

Best regards,

EmreT

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
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...

529 views 19 25
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