How to extract duration of each status in eazybi?

[Safa Al Shuaili]

How to extract duration of each status in eazybi by working days of each issue?

[Vitalii_Bobak_SaaSJet]

Hi @Safa Al Shuaili  👋
Welcome to the Community!

If you consider installing third-party add-ons, option for you can be Time In Status. Add-on has integration with eazybi, but its easier to extract duration of each status in your Jira. For this just:

1. Choose Project, Assignee, Sprint etc.
2. Filter issues by Time Ranges
3. Enjoy you report as Table or Chart view. 

2. Also the Assignee time report can be useful for you. This report will notify you of how much time each Assignee spent on each task.

3. Also you can see Time in States Metrics as a Dashboard Gadget. For an example how long a task was in progress on each Assignee or how long it was Unassigned. You also have a Table or Chart view for this.

   

4. For more in-dept analysing try out Pivot view table. We can evaluate how much the time in the In Progress status has changed depending on the number of tasks, and we can also “dive deeper” and see which tasks have spent a lot of time.

Add-on developed by my team.

You can also book a live demo - we'll show you the application inside out and answer all your questions.

I hope you find this helpful 🚀

[elita_kalane]

Hi @Safa Al Shuaili 

To see the duartion of statuses you can use measure "Workdays in transition status" along with the Transition status dimension in Columns. 

You can take a look at our demo dashboard report here, which also includes an example of how to include a measure that checks how much time the issue has spent in current status https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-issue-days-in-selected-status

The example is given with "Days in transition status", but you can adjust the measure and replace them with measures "Workdays in transition status".  Here is a link to instructions on how to export the report definition and import it into your own account - https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions

Let me know if you have any follow-up questions!

Best wishes,

Elita from support@eazybi.com

[Gizem Gökçe _OBSS_]

Hello @Safa Al Shuaili ,

Welcome to the community!

If you're looking to extract the duration of each status based on working days, Timepiece - Time in Status for Jira is an excellent solution. Plus, it integrates with eazyBI, making it easier to visualize and analyze your data.

Timepiece is developed by my team at OBSS and is the oldest and leading 'Time in Status' app in the Atlassian Marketplace. It is designed to calculate how much time each issue spends in each status, and it offers features to ensure accuracy by considering working hours, holidays, and non-working days through its Custom Calendar functionality.

How to Achieve This with Timepiece:

1. Integrate with eazyBI (Optional):

   • If you're already using eazyBI, you can use Timepiece reports to feed data directly into eazyBI for advanced visualizations. Timepiece provides reference documents to guide you through this setup.

2. Set Up Custom Calendars:

   • Define your working hours, weekends, and holidays.
   • For teams with different schedules, configure multiple calendars tailored to their needs

3. Generate a Status Duration Report:

   • Use the Status Duration report in Timepiece to see how long each issue spent in every status.
   • Apply your custom calendar to ensure calculations reflect working days only.
   • 

4. Export or Analyze Further:

   • Export your report in CSV or Excel format for additional analysis or use it directly with tools like eazyBI.

With these capabilities, Timepiece simplifies tracking and helps you make data-driven decisions. Learn more about how Timepiece can enhance your Jira reporting here.
To see Timepiece in action, I recommend checking out our live demo. Let me know if you have further questions or need guidance setting this up!

Hope it helps!