Using JQL or any query really in an existing report

I’m trying to add a column into an existing EazyBI report for our environment. The problem is, I want to pass it through some condition before it appears there. Since the rest of the report needs all the data, I cannot filter it on import. For this one column, we want to make sure Field “XYZ” which has options “A”, “B”, “C” and “none” has “C” option checked drilled across another field “PQR” and for the second column I want a combined value of “A”, “B” and “none” again drilled across “PQR”. Is it possible to create this, or do we need separate reports?

Hi @riskar,

There is an option to define in which CASE to show each measure. In the following example, I have defined report specific measures to show Issues created based on two different contexts - while All Projects and All priorities are selected, I’m showing only in specific cases and Hiding the rest:

  1. the First option - showing only for Project “DEMO Alfa” and “All Priorities”
CASE WHEN
  [Project].CurrentMember IS [Project].[DEMO Alfa] AND
  [Priority].CurrentMember IS [Priority].DefaultMember
THEN [Measures].[Issues created]
END
  1. the Second option - showing for All Projects, but only for two priorities
CASE WHEN
  [Project].CurrentMember IS [Project].DefaultMember AND
  [Priority].CurrentMember.Name MATCHES "High|Highest"
THEN [Measures].[Issues created]
END

While both options show for All and individual Statuses:

Lauma / support@eazybi.com