Time to first response for issues without certain labels

Questions & Answers
2

Hi @hedmaeli

120k issues is challenging number of issues in account if you use a formula with Descendants function that goes through “Issue” dimension members.
here, the best would be using a Javascript code in advanced settings to precalculate the results during import. Then you can import this new precalculated field as dimension and filter the results without using Descendants function

Try this Javascript for the calculated field:

[jira.customfield_donotreport]
name = "Do not report"
data_type = "string"
dimension = true
javascript_code = '''
var labellist = ["label1","label2"]; 
var newlist = new Array;
if (issue.fields.labels){
issue.fields.labels.forEach(function(label){
if (labellist.indexOf(label) != -1 ) {
var dnr = newlist.push("Yes");
}
})};
if(dnr)
  {
    issue.fields.customfield_newlabel = "Yes"
  }
'''

That would create a new calculated field “Do not report” with value “Yes” if the issue has one of defined labels (label1 or label2). Once this field is imported as dimension, you could select the value “(none)” from the new dimension and use it with the measure “Time to first response issues” and it should work fast enough with 120k issues in the report.

Martins / eazyBI support