JQL in easyBI - if Condition fields

Hi,
we use different categories (insight field) in our project. Now we just need to show three of them, when the root cause analysis is GDPR Beschwerde.
JQL is: project = BM AND (Category != Datenanfrage OR (Category = Datenanfrage AND “Root cause analysis” = “GDPR Beschwerde”))

Hi @Eva_Rehn,

Welcome to the eazyBI community.

If you need only to have relevant issues within the data cube and all reports in the specific eazyBI account, you might apply that JQL during the data import process. Please read more about that here - Data from Jira.

However, if these conditions apply to one measure or one report only, you might create a calculated measure within the Measures dimension that filters the issues accordingly.

For example, the expression to find the number of issues compliant with the provided JQL might look as follows.

[Measures].[Issues created]
-
([Measures].[Issues created],
 [Category].[Datenanfrage])
+
([Measures].[Issues created],
 [Category].[Datenanfrage],
 [Root cause analysis].[GDPR Beschwerde])

However, the actual expression depends on your requirements.

Regards,
Oskars / support@eazyBI.com