Overdue interval
eazyBI for Jira
The "Overdue interval" dimension can show overdue issues by overdue intervals.
In this new dimension, the (none) member will count issues without a due date, and member "... - 00" represents issues with a due date in the future.
Other issues are overdue, and they are grouped according to intervals setting "0-30/10"
- 00 - 09 - overdue issues with due date between today and 9 days ago.
- 10 - 19 - overdue issues with due date was between 10 and 19 days ago.
- 20 - 29 - overdue issues with due date between 20 and 29 ago
- 30 - ... overdue issues with due date more than 30 days ago
You can adjust the interval definition later from the report builder when the field is imported as a dimension. But there can be just one definition per dimension.
Account-specific calculated field
Account specific calculated fields are defined in Source Data → Import options.
Settings for the new field
| Internal name | overdueage |
|---|---|
| Display name | Overdue interval |
| Data type | decimal |
| Dimension | ✓ |
| Measure | ✓ |
| Additional advanced settings | time_unit = "seconds" |
Custom JavaScript code:
return Math.floor(Date.parse(issue.fields.duedate) / 1000);
Global calculated field
Global calculated fields are defined in eazyBI advanced settings.
Here are the settings for the new field definitions. You should insert the JavaScript (the code given above) below the line // Insert here the Custom JavaScript code. Keep the opening and closing quotation marks. ''', do not delete them.
[jira.customfield_overdueint] name = "Overdue interval" data_type = "decimal" dimension = true measure = true javascript_code = ''' // Insert here the Custom JavaScript code ''' time_unit = "seconds" time_interval = "age" intervals = "0-30/10" interval_unit = "days"