Measure : issue count with delay when transition

Questions & Answers
1

Hello,

I have issues with custom attributes:

  • initial delivery date
  • scheduled delivery date (filled when in progress or closed)

I would like a report which show

  • Rows: time
  • Columns, for each month:
    - the number of issues (closed during the month) with a delay (“scheduled delivery date” - “initial delivery date”) less than 10days, between 10 and 20days and more than 20days.
    - the number of issues in progress with a delay less than 10days, between 10 and 20days and more than 20days.

Thank you in advance for your help
Ludovic

2

Hi @Ludovic,

I recommend defining a custom interval dimension with JavaScript calculated custom fields to view the current delay. See an example here with a custom resolution interval - Custom resolution interval.

Specify the desired date custom fields in the JavaScript code and adjust the interval settings. Test the configuration with particular issues to see if the results are correct. After that, import the interval dimension and select it in your report columns.

To view the number of issues closed during that month with the particular delay interval, use the measure “Issues closed” or “Issues resolved” if you are looking for the resolved issues.

To view the number of issues “In Progress” at the end of each month, you can use the measure “Issues history” in combination with the Transition Status dimension “In Progress” in a new calculated measure as a tuple - Calculated measures.

Please note, while issues history will provide historical information of the number of issues “In Progress” at the end of each month, the issues will be grouped with the interval dimension by their current delay.

Best,
Roberts // support@eazybi.com