Customizing Issue Duration Report with Stories in Rows and Detailed Duration in Columns

Hello eazyBI community,

I’m reaching out for assistance with creating a custom report in eazyBI that displays a list of stories in the rows and detailed duration spent in each status in the columns. The goal is to get a clear overview of the time spent in each status for each story within a specific project and date range.

Project and Status Context:

Our project has the following statuses:

  1. Backlog
  2. PO Review
  3. Ready for Development
  4. In UAT
  5. Ready for Production
  6. Market Live

Requirements:

  1. Filter issues by type: Story
  2. Filter issues by project: [XYZ]
  3. Filter issues by date range: [Insert start and end dates, e.g., “January 1, 2022 - December 31, 2022”]
  4. Display a list of stories in the rows
  5. Calculate the duration spent in each status for each story and display it in the columns
  6. Display the duration in a human-readable format (e.g., “X days”, “Y weeks”, etc.)

Example Output:

Question:

Can anyone provide guidance on how to create a custom report in eazyBI that meets these requirements? I’d appreciate any help with the necessary eazyBI syntax, formulas, or configuration settings to achieve this.

JIRA version : Jira v9.12.11 Data Center
eazyBI for Jira (version 7.2.1:node1)

Thank you

Hi @sherif_ahmed,

Welcome to the eazyBI community :tada: !

Please have a look at the following report from the eazyBI demo account - Issue days in selected status - Issues - Jira Demo - eazyBI. It gives you two options on how to represent the duration in status. The predefined measure “Days in transition status” will return the duration issues spent in a particular status once they are transitioned out of the status. The calculated measure “Days in transition status till now” will include the duration the issues are currently in as well.

To view the duration in human readable format, I recommend using the built-in duration formatting option “##d ##h ##m Days, hours, minutes” - Calculated measures. This would require the measure values to be returned in minutes. So, the results must be multiplied by 24 hours and 60 minutes. For “Days in transitions status”, the formula would look similar to the one below:

[Measures].[Days in transition status] * 24 * 60

By which issue date do you want to set the time range?

You can export the demo account report definition and import it into your eazyBI - Export and import report definitions.

Best,
Roberts // support@eazybi.com