Guy,
You need to create a new custom calculated field using the Javascript for the solution.
These advanced settings create a new measure giving the number of days for the Impediment status for the completed cycles (when the Impediment flag was also removed from the issue):
[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;
'''
Kindly,
Janis, eazyBI support