Hi,
Welcome to the eazyBI community!
I suggest implementing this calculation with JavaScript in Jira import options as a custom field: Custom field import options
The JavaScript could look like this:
var Type = issue.fields.issuetype.name;
var Labels = issue.fields.labels;
var RType = "(none)";
// Function to check if a label exists in the Labels array
function hasLabel(label) {
return Labels.includes(label);
}
// Determine the value of RType based on the conditions
if (Type === "Task" || (Type === "Bug" && hasLabel("NoTriage"))) {
RType = "Type 1";
} else if (Type === "Bug" && (!hasLabel("NoTriage") || Labels.length === 0)) {
RType = "Type 2";
}
return RType;
Define the field and import it as a dimension and a property and you will be able to use it in the report as any other dimension or property:
Kindly,
Ilze