Help converting JQL to calculated measures

Hi all,

I am trying to convert the following simple JQL filters for use within a timeline EazyBi report.

  1. Type = Task OR (Type = Bug AND Labels in (NoTriage))
  2. Type = Bug AND (Labels not in (NoTriage) OR Labels IS EMPTY)

I am using in/not in as the list of labels may change over time, but unlikely.

The EazyBi report, as mentioned above, is a timeline view where the above measures would be used to refine the scope

Rows = Time
Measures include: Story Point history, predicted completion dates, etc, example below
Multiple Page filters too

I have tried using a combination of Filter, Aggregate and Exclude but just cannot seem to get this to work.

Any advice?? Many thanks

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