Jira JQL in EazyBI Custom Measure as a Filter

Hi @yyy

Welcome to eazyBI community!
It seems that you reached out to us directly with the same topic. I will paste the answer here below, incase other eazyBI users also have similar use case.

You could try creating a new calculated field (New calculated fields) with the setup I have shown in the screenshot below.

In Additional advanced settings you should add

csv_dimension = true

in Custom JavaScript code, you should add:

return issue.fields.labels

This will create a new dimension “Alternative Labels CSV” which allows you to filter issues that have one single label or multiple label combinations.
64e37a548c13ee32688dde4f65de42e4.png
Here is a community post about importing Label dimension as CSV dimension Aggregate # of issues with multiple labels (Label 1 AND Label 2) and provide the count of issues per each release - #2 by roberts.cacus

If this solution doesn’t work for you, then I suggest considering adding a JavaScript code in advanced settings. You can read about the solution in this community post - Story points by label, excluding/including other labels

Best wishes,

Elita from support@eazybi.com

2 Likes