All eazyBI for Jira eazyBI for Confluence Private eazyBI

Cascasing field concatenated
eazyBI for Jira

Calculated field to concatenate cascading field both levels into a single value dimension. Replace NNNNN with the customfield ID from Jira.

Account-specific calculated field

Account-specific calculated fields are defined in Source Data → Import options.

Settings for the new field

Internal name

conccascf_NNNNN

Display nameConcatened field
Data type

string 

Dimension

Additional advanced settings
json_fields = ["customfield_NNNNN"]

Custom JavaScript code:

var result;
var cfdef = issue.fields.customfield_NNNNN; //replace with customfield ID
if(cfdef){
  if (cfdef && cfdef.child) {
  result = cfdef.value + " | " + cfdef.child.value;
  }
  else result = cfdef.value;
  }
if(result){
return result;
}

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 codeKeep the opening and closing quotation marks. ''', do not delete them.

[jira.customfield_conccascf_NNNNN]
name = "Concatenated fieldname"
data_type = "string"
dimension = true
json_fields = ["customfield_NNNNN"]
javascript_code = '''
  // Insert here the Custom JavaScript code
'''