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 name | Concatened 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 code
. Keep 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 '''