Days in Current Status Report

Questions & Answers
1

trying to generate a report that shows only the number of days in the current status but appears that using status give the a cumulative time an issue has been in a specific status not jus the current time. I am looking to capture something like the JIRA Time in Source Status from JIRA

EazyBI%201
EazyBI 1.png1837×611 46.3 KB

I have code that appears to work to get the correct number of days an issue is in a given status but can not figure out how to take it from a table to a graph

Ezybi%203
Ezybi 3.png1842×681 108 KB

2

Hi Brian,

it seems you may want to benefit from Age in current status interval dimension (instead of Age dimension). This would be a custom dimension.
To get such a dimension, the following steps would be needed:

1.Start with creating a new calculated custom field in eayzBI advanced settings by pasting there the code below:

[jira.customfield_ageinstatus]
name = "Age in current status"
data_type = "integer"
dimension = true
javascript_code = '''
ageinstatus = 0;
issue.changelog.histories.forEach(function(history){
  history.items.forEach(function(historyItem){
    if (historyItem.field == "status") {
     ageinstatus  = Math.floor(Date.parse(history.created) / 1000);
    }
  });
});
if (ageinstatus == 0) {
	ageinstatus = Math.floor(Date.parse(issue.fields.created) / 1000);
}
issue.fields.customfield_ageinstatus = ageinstatus;
'''
time_unit = "seconds"
time_interval = "age"
intervals = "15,28,42,56"
interval_unit = "days"

The formula above calculates time in the last status and creates intervals for 15 days, 15-27 days, 28-41 days, 42-56 days, and more than 56 days.

  1. After updating settings, you should import this field into eazyBI as a dimension. For that, open import settings for edit and select this custom field for import as a dimension. Then run data import. During that, a new dimension ‘Age in current status’ will be created.

  2. In the report, you can use the default measure ‘Issues created’ and this new dimension ‘Age in current status’ in rows and ‘Status’ dimension in columns.

For more detailed assistance, please contact eazyBI support via email support@eazybi.com

Ilze, support@eazybi.com

3

Hi Ilze,
Is there a possibility to create a similar dimension, but not for days in status, but days since last updated? We are currently trying to catch issues that are just forgotten and counting them with filters is rather slow

4

Hi Ilze,

Could you help to amend this to “age since submitted” or “age since first time transition to status (submitted)”?

[jira.customfield_ageinstatus]
name = “Age in current status”
data_type = “integer”
dimension = true
javascript_code = ‘’’
ageinstatus = 0;
issue.changelog.histories.forEach(function(history){
history.items.forEach(function(historyItem){
if (historyItem.field == “status”) {
ageinstatus = Math.floor(Date.parse(history.created) / 1000);
}
});
});
if (ageinstatus == 0) {
ageinstatus = Math.floor(Date.parse(issue.fields.created) / 1000);
}
issue.fields.customfield_ageinstatus = ageinstatus;
‘’’
time_unit = “seconds”
time_interval = “age”
intervals = “15,28,42,56”
interval_unit = “days”

5

Hi Elvis,

There is an example of JavaScript code to create a dimension “Age since updated interval”: https://docs.eazybi.com/display/EAZYBIJIRA/JavaScript+calculated+custom+fields#JavaScriptcalculatedcustomfields-Customcalculatedfieldasanintervaldimension

Ilze

6

Hi Ilze,

Good to see you again!! I love this new code for creating these intervals in the current status dimension. I tried to add this code to my advanced settings and I got an error. There error I got was “invalid top level keys: database”.

Any ideas?