Iryna Komarnitska_SaaSJet_ Community Champion

Hi @thumuluru.shreya , In this article, we've covered the use case of using pivots for such reports. Check it out; you might find it useful.

Hi @SHRUTI GOYAL , The sprint report in the Time in Status app (developed by my team) can be used to analyze the sprint. There, you will see all the necessary metrics to evaluate the sprint performance and the carryover indicator in case tasks are transferred to the next sprint.

Hi @Ana Figuera , Try using the Time in Status app. My team developed it. Various reports can help you track the time an idea has been in a particular status. By analyzing the reports, you can identify bottlenecks, improve the team's performance, or optimize the project's workflow. In these articles, we've described all…

Hi @Shrushti Shah , If I may suggest, you need to measure the Time Between Statuses metric more. Because you need to measure transitions between statuses precisely. My team has created such an app. You create a group status and have the opportunity to see the calculation in the report. You can set up notifications for…

My comment is here to get updated answers to this question

Hi @Ushna Sarfaraz If you don't mind third-party apps, I can recommend the Time in Status app, developed by my team. In it, you can generate a Time in Status report separately for each sprint. Make pivot tables to analyze sprints. The app also allows you to generate a separate Sprint Performance Report. For you - 30 days…

Hi @Cristiane Gonçalves , If you don't mind third-party apps, I recommend the Time in Status app, developed by my team. The board column is equal to the concept of Issue Status. Therefore, you need a regular Time in Status report. In addition, the app has other types of reports: Assignee Time, Average Time, Status Entrance…

Hi @Dinonath Khan The comments here have already suggested an add-on from my team - Time in Status. I want to share ways to achieve what you want with it. 1. The usual Time in Status report. It shows you how long tasks were in each of the workflow statuses. 2. The Assignee time report will notify you of how much time each…

Hi @Tamás Szalisznyi , issuein linkedIssues("MARC-4147") - example of a query that worked for me. This JQL showing you how to search by link, not by parent/child relationship. IFA2-2693 - This task, as I see it, is epic. Therefore, you must use a different JQL here - parent = IFA2-2693 . Below is an example of the result:

Hi @Zsigmond Molnar, JQL does not calculate the value of how long an issue has been in statuses. It would help if you used third-party apps for this. If you don't mind this solution, I recommend using the Time in Status app by SaaSJet (my team developed this add-on). So, you can get the report you need by using one of the…

Hi @Vronik , Thank you very much! I'm glad you found it interesting.

Hi @gouthamrajesh02 , Thank you for your comment. Yes, I want to delve deeper into time management techniques and further explore them. If I find something interesting, I will share it with everyone in the Atlassian Community.=)

Hi @Kelsey LaMastres _Appfire_ , Oh, I'm also a fan of the Eat That Frog technique. The main thing for me is to avoid falling into procrastination and don't collect "frogs". Otherwise, Friday night may come, and all five-workdays-old "frogs" may be sitting around you croaking. 😂 So, I try to combine this technique with the…

Hi @Bhatt_ Reddhi Uday _external_ , I can advise you to try to estimate the time spent based on the time in status metric. My team has developed the Time in Status for Jira - Reports | Charts | Dashboard app. With it, you can calculate Lead Time, Cycle Time, Wait Time, and other metrics by creating status groups. The app…

@Harvinder kaur I tried this JQL and managed to pull epic+tasks that are linked to it. Could you tell us more about what you need this request for? Do you need to analyze data by task further, or do you just need a report for external users?

Hi @Harvinder kaur , Try this query. It will pull up all the tasks belonging to a particular epic for you issuetype = sub-task OR "parentEpic" IN (Epic Key) AND project = "Project name" 

Hi @Jake S , My colleague has created a useful collection of JQL queries for Time in Status reports. I hope you find it useful!

Hi @Josh Goedert , This article contains a selection of JQL queries for Time in Status reports. With their help, you can select tasks, export them, and continue creating a report (calculating data, creating charts, etc.) in Excel or Spreadsheets. Still, if you're considering using a third-party app, try Time in Status from…

Hi @Norma Welcome to the Community! If you're interested in time metrics and how to interpret and measure them, I can recommend articles written by my team: * Time in Status in Jira: What is it and how to track? * Insights from Time in Status, Cycle Time, Lead Time and beyond metrics * From To Do to Done: Analyzing Time…

Hi @Santhosh Raj , Try using the Time in Status for Jira - Reports | Charts | Dashboard app (developed by my team). The app has a feature that allows you to display the time in status in custom fields. Here, the documentation describes how to configure this option. You have a 30-day free trial to get to know the app…

Hi @Jojibabu , You can try using the app Time in Status for Jira—Reports | Charts | Dashboard, which my team developed. The Total column on the grid summarizes all time in statuses in which issues were during a particular period. The Column Manager feature helps you subtract statuses you don't need to consider from the…

Hi @Centro de Excelecia TI , I can advise you to use an app developed by my team. Time Between Statuses is an addon designed to calculate the time between statuses and measure various time KPIs based on these calculations. The screenshot shows an example of a report for the Support team. It illustrates how the required…

Hi @Sachin Guttala , You might also try this query: Project = XXX AND status changed to Done ON (2024-03-18, 20024-03-24) AND NOT updated IN (now())

Hi @Devi , I can offer you a solution - directly add the amount of time spent in the status to the issue card. This is possible with the Time in Status for Jira app (developed by my team). Here's a link to the detailed set guide. The app has a 30-day free trial. I hope this will be useful to you.

Hi @Anjali Kumari , Welcome to the Community! Try this JQL query statusCategory = "Done" AND resolutiondate >= startOfDay() Instead of Done, there can be any other status, which in your workflow means the task is closed. Also, suppose you're interested in more advanced reports on time in status, finding bottlenecks to…

Hi @Johnny Wong , I can also recommend articles written by my team: * Time in Status in Jira: What is it and how to track? * 🚀 Boosting Productivity with Assignee Time Reports 🚀 * Insights from Time in Status, Cycle Time, Lead Time, and beyond metrics * Navigating Blockers, Stuck Issues, and Flags for Seamless Project…

Hi @GL Communications , There are several ways to estimate an assignee's workload within a sprint. 1. You can use the built-in gadget for Jira Dashboard - Workload Pie. 2. There is another way. It is more complicated because it requires deeper analysis. I'm talking about the time in status metric, which will help you…

Hi @Khalid Qassadi , Try using the Time Between Statuses app. This is a development of my team. The app is designed to calculate various time KPIs. You can generate timers within each project and define task warning and critical time limits. If this time is exceeded, you will receive a notification in the task and by…

Hi @Nina Andrić , If I have understood you correctly, then perhaps your request can be resolved in this way: A report can be generated as a pivot using the Time in Status for Jira—Reports | Charts | Dashboard app developed by my team. You need to select the Time in Status report and filter the tasks by a specific sprint.…

Hi @Tushar Rajvanshi , I can advise you to use the Time in Status for Jira - Reports | Charts | Dashboard app developed by my team. With it, you can quickly generate Time in Status reports. You can customize your team's work schedule; the calculation will only be based on working hours. You can save frequently used report…