I would like to build a report to show flagged stories and how long they have been flagged for?
I do not have the option when I import. I believe I would need to do a new calculated field. Can someone provide me that code?
I used the code below but get an error.
[jira.customfield_days_flagged]
name = "Days Flagged Impediment"
data_type="decimal"
measure = true
javascript_code='''
var date_from = Date.parse(issue.fields.created);
var days_flagged = 0.0;
issue.changelog.histories.forEach(function(history){
history.items.forEach(function(historyItem){
if (historyItem.field == "Flagged") {
to = historyItem.toString;
from = historyItem.fromString;
if(to.equals("Impediment")) {
date_from = Date.parse(history.created);
}
if (from && from.equals("Impediment")) {
date_to = Date.parse(history.created);
days_flagged += (date_to - date_from) / 1000/ 60 /60 / 24 ;
}
}
});
});
if (days_flagged>0) issue.fields.customfield_days_flagged=days_flagged;
'''
