Building the Eazybi Report for the specific JQL scenarios

Questions & Answers
1

Hi,

Can I please get the help to create the report with the below jql in eazybi.

Project = CDS and type = “User Requirement” and “R2.0 Usage Indicator[Dropdown]” in (new, “Functional Change”, “Use as is”) and “Fit/Gap Classification[Dropdown]” = Fit AND (“Implementation Workstream[Dropdown]” in (“ALX-R&A Operations”) OR (“Implementation Workstream[Dropdown]” IS EMPTY AND “Workstream[Dropdown]” in (“ALX-R&A Operations”)))

I want to see both these scenarios:

  1. When “Implementation Workstream” = ALX-R&A Operations
  2. AND if “Implementation Workstream” is EMPTY, then look up Workstream = ALX-R&A Operations.

Thanks in Advance.

2

Hi @Amzad

I’ll format the JQL query so it’s more understandable:

Project = CDS 
AND 
type = “User Requirement” 
AND 
“R2.0 Usage Indicator[Dropdown]” in (new, “Functional Change”, “Use as is”) 
AND 
“Fit/Gap Classification[Dropdown]” = Fit 
AND 
(
    “Implementation Workstream[Dropdown]” in (“ALX-R&A Operations”) 
    OR 
    (
        “Implementation Workstream[Dropdown]” IS EMPTY 
        AND 
        “Workstream[Dropdown]” in (“ALX-R&A Operations”)
    )
)

First, you need to import all these custom fields as Properties into eazyBI: Data from Jira

If you want to count the number of issues that will be returned by this JQL query then you can create a new measure in the Measures dimension with a formula like this:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    -- Filter the issues based on Project and Issue Type
    (
      [Measures].[Issues created],
      [Project].[CDS], -- Change to the Project name saved in eazyBI, check auto-suggest
      [Issue Type].[User Requirement]
    ) > 0
  ),
  -- Check the Issues Properties for the necessary values
  CASE WHEN
    CoalesceEmpty([Issue].CurrentMember.Get("R2.0 Usage Indicator[Dropdown]"),"")
    MATCHES "New|Functional Change|Use as is"
    AND
    [Issue].CurrentMember.Get("Fit/Gap Classification[Dropdown]") = "Fit"
    AND
    (
      [Issue].CurrentMember.Get("Implementation Workstream[Dropdown]") = "ALX-R&A Operations"
      OR
      (
        IsEmpty([Issue].CurrentMember.Get("Implementation Workstream[Dropdown]"))
        AND
        [Issue].CurrentMember.Get("Workstream[Dropdown]") = "ALX-R&A Operations"
      )
    )
  THEN
    1
  END
)

Please check that the Project name in this formula is the same as imported into eazyBI. Please also check that the property names are written exactly as they are imported. These functions are case-sensitive.

​Best regards,
​Nauris