How to create a custom field on import based on Reporter Group and a Label?

Questions & Answers
,
3

Hi @Kristine
​
For your use case I recommend creating a new custom field “Source” by writing a JavaScript code. Here is a community post which is very similar to your requirements - Combine Calculate measure and Calculate member in report columns - #5 by michailgoruynov.
​
​The JavaScript code for your scenario might look as follows, where you replace MMMMM with your custom code ID for the Reporter Group. Once you have updated the eazyBI advanced settings with this code, import the custom field “Source” as a dimension and property.
​

​[jira.customfield_source]
name = "Source"
data_type = "string"
dimension = true
javascript_code = '''
// Set Source to QA
if (issue.fields.labels == "caught-by-qa" || issue.fields.customfield_MMMMM && issue.fields.customfield_MMMMM.value === "qa") {
    issue.fields.customfield_source = "QA";}
​else
// Set Group to Support
   if (issue.fields.customfield_MMMMM && issue.fields.customfield_MMMMM.value === "Support") {
    issue.fields.customfield_source = "Support"} 
​ else {issue.fields.customfield_source = "Other"}

'''

​
​Best wishes,
​Elita from support@eazybi.com
​
​