Converting a JQL into an EazyBI measure

Hello,
I’m trying to convert a JQL into an EazyBI measure.
The JQL is: project = XXX AND issueFunction in portfolioChildrenOf(“status = implementation”) AND issuetype = Epic AND fixVersion is EMPTY AND status not in (resolved, closed) AND component not in (AAA, “BBB”, “CCC”).
Is this possible?
Thank you!

Hi @Gnome,

Most of the JQL criteria could be replicated in eazyBI as page filters (project, issue type, fix version, status).

To filter issues by parent issue status and children status, you might want to import link field dimension representing the parent issue status. This way you can create dimension like “Epic Status” or “Feature status” and use it on report pages as a filter. For more details and examples see the documentation: Issue link field dimensions.

A component filter might be the most challenging part as the component is a multi-selection field and filtering issue matching any component except for AAA, BBB, CCC include issues with one matching component KKK and another excluded component AAA. In other words, when filtering data by multi-selection field and excluding issues with specific values, you should consider the whole component combination assigned to each issue.
You might want to import issues Components and Component combinations as separate dimensions using JavaScript calculated custom fields: JavaScript calculated custom fields. The code might look like this:

# Component as dimension and CSV dimension
[jira.customfield_eazybicomponent]
name = "Component"
data_type = "string"
multiple_values = true
split_by = ","
csv_dimension = true
dimension = true
javascript_code = '''
issue.fields.customfield_eazybicomponent = issue.fields.components;
'''

Then on report pages, use dimension “Component CSV” representing used component combinations to filter by all combinations except ones containing AAA, BBB, or CCC components.

More details and examples of how to transform JQL filters to eazyBI reports are in the presentation: Translating-JQL-Queries-to-eazyBI-Reports-by-Janis-Plume-eazyBI.pdf - Google Drive

Best,
Zane / support@eazyBI.com

Tank you @zane.baranovska , most helpful.