Hi all,
I am trying to convert the following simple JQL filters for use within a timeline EazyBi report.
- Type = Task OR (Type = Bug AND Labels in (NoTriage))
- 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