time in status - report

[Uma Sanjeevi]

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 

[Mariana_Pryshliak_Saasjet · Accepted solution]

Hello @Uma Sanjeevi 

You can try Time in Status for Jira Cloud developed by my team.

The add-on generates a report on how long an issue has been staying in each status (Testing, In progress, etc). Additionally, you'll get 7 reports that show

• Time in Status

• Assignee Time

• Average Time

• Status Entrance Date

• Time in Status per Date

• Status Count

• Transition Count

You can view data as a Table or Chart. And use a Pivot to customize your reports as you need. If you have any additional questions, I'm here to help you. Here is online demo where you can try it without installing

Best regards, Mariana.

[Uma Sanjeevi]

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

[Uma Sanjeevi]

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 ?

[Mariana_Pryshliak_Saasjet]

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.

[Uma Sanjeevi]

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 

[Zoryana Bohutska _SaaSJet_]

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

[sivakopparapu]

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

[Deleted user]

Can we rearrange the column?

[Mariana_Pryshliak_Saasjet]

Hi @[deleted] 

Yes, the add-on gives such ability to rearrange the column.

[Deleted user]

Thanks! I manage to re-arrange it now

[Bloompeak Support · Accepted solution]

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.

[Uma Sanjeevi]

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]

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.

[Uma Sanjeevi]

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

[Bloompeak Support]

@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]

@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.

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
|___...

[Marianne Miller]

@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]

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.

[Emre Toptancı _OBSS_ · Accepted solution]

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.

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

[Akash Yadav]

Hi Emre, We are using Jira ITSM platform in our organization. Jira is deployed by one of the SI in India.

I am facing issues in terms of few specific reports. Wanted to understand from you if you can help. I am reachable on akash.yadav1@industowers.com

I have a report of Symphony Summit which i am expecting in Jira through any of the plugin. This report gives me a clear view on ticket was assigned to which group at first and how much time it took. if it is hopped to second group that how much time it took and so on. Where resolver can easily track how much it took by there respective group to resolve the issue and rest other time will not be counted in there SLA as ticket was with some other group

Regards

Akash Yadav

[Emre Toptancı _OBSS_]

Hello Akash,

I'll be reaching you via e-mail.

EmreT

[Antuan Sammak _ FusionTech Innovations]

Hello,

You might want to give a try our new application  it offers a new approach of reporting that shall help your organization and teams to analyze teams performance and identify potential improvements.

Also please feel free to raise any feature change or new app concept that you think it will be useful to have it through our Portal and we would be happy to work on it.

Thank you in advance for considering our solutions.

FusionTech Innovations

[Levente Szabo _Midori_]

An alternative way to create time in status reports in Jira is by using the "Time by Status" export option provided by Better PDF Exporter for Jira.

It offers a simple way to include a time in status report in exported PDF documents without installing any other app.

Better PDF Exporter comes with a template that calculates time between transitions when you export a Jira issue.

Learn the steps of how to generate a Jira time in status PDF report in this article or other Time by X-type reports.

[Uma Sanjeevi]

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  

[Emre Toptancı _OBSS_]

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

[Emre Toptancı _OBSS_]

Hello @Jenwit Suwannakote

I couldn't understand what you need. Can you give some more details? Or you can reach our support team via plugin@obss.com.tr

Thanks