how can i get Time in Status without any plugin?

Amelie Allen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 29, 2024

I need Time in Status without any plugin. Can i get it with JQL?

5 answers

1 accepted

0 votes
Answer accepted
Valeriia_Havrylenko_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 29, 2024

Hi @Amelie Allen  👋

Unfortunately, there is no way you can find with native features, but you can achieve it with JQL. You can find a suitable JQL in this article → JQL Time in status reports

 

But since you are on a free Jira, you will not pay for Time in Status

With our add-on, you have the power to tailor your team's work schedule, ensuring that the calculation is based solely on productive working hours.

Frame 1021.png

For more in-depth data analysis, you can create reports as pivots. For example, you can look at the percentage of time spent in different statuses.

Frame 1034.png

Dashboards gadgets feature will keep your finger on the pulse and track team productivity in real-time.

Add-on has 30-day free trial, free up to the 10 users and developed by my team. 

I hope you find this helpful 🚀 

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 1, 2024

Hi @Amelie Allen

welcome to the community!

As you've certainly noticed by now, this is an area that isn't well supported by Jira natively, which is why a number of Marketplace apps operate in this space. Just be aware that you can trial any for free for up to 1 month - so if an app should become an option for you, perhaps try a few and see which one works best for you.

To provide another concrete recommendation, I think you might like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including time in [status], time between [status] and [status], and many moreThis is how it looks in action:

time-in-status-v2.gif

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

 

0 votes
Amay Purohit_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 30, 2024

Hi @Amelie Allen 

 

Welcome to the community !!

 

You can use Jira Rest API's to pull this data. Or as an alternate if your fine to try out mktplace app, take a look at

Time in Status Reports 

The app has 20+ reports to meet a variety of use cases. The standard time in status report in the screen grab below should suffice the requirement. Hope this helps.

More details here

The app is free for 10 users. Do try it out.

Disclaimer : I work for RVS, the vendor for this app

TIS-1.png

0 votes
Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 29, 2024

Hi @Amelie Allen ,

Welcome to the community!

It is not possible with the built-in JQL functionalities. However, the data you need is available in issue history and you can get it using the issue REST API. Then you need coding to parse the json response and get the exact status transition date for each issue.

Another alternative is to search for free marketplace plugins.

0 votes
Gizem Gökçe _OBSS_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 29, 2024

Hello @Amelie Allen ,

Welcome to the community!

One way is to use the Jira Rest API's to pull Time in Status data from issue histories. However, building such a solution will be very time consuming for you. Every time JIRA is updated, there may be changes to the API's, the structure of the data, the structure of the issue history and so on... So you have to constantly check your code and make new adjustments. This means that you also have a maintenance (time) cost for this.

Your second option, is to use Jira Automation to do the calculation yourself and store the result into a custom field, and then view the custom field in a Jira report. Please have a look at this article. However, this method also takes time to understand and apply.

In the Atlassian ecosystem, most people use 3rd party applications, which we call plugins, to extend the capabilities of the core Jira. So in a nutshell, if you are in the Atlassian ecosystem, I suggest you get used to using plug-ins to solve your problems. Plug-ins will save you time and additional maintenance costs.

Therefore, for your needs, your 3rd and best option is to use a plug-in. For this, I can recommend Timepiece (formerly Time in Status) ,the oldest and leading "Time in Status" app in Atlassian Marketplace which is developed by my team at OBSS.  Our app is available for both Jira Cloud, and Data Center. As far as I can see, you are on the free product plan. Our app is also free for up to 10 users. So you don't have to make any additional payments to use our app. 

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events