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?
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.
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
Zane / support@eazyBI.com
Tank you @zane.baranovska , most helpful.