Calculated field that works in Jira JQL but not in EazyBI MDX

Questions & Answers
1

Hello,

does anybody know how to write MDX code for the following JQL code:

project = “xyz” and assignee was in membersOf(“group1”) and assignee not in membersOf(“group1”)

Thank you!

2

Hi @zanzanzan,

JQL could be transformed into eazyBI reports and calculations. Simple queries usually are transformed as reports with particular values selected for rows, columns an pages. More complex queries are processed using calculations in dimensions and measures.
More information and examples of how to translate JQL queries to eazyBI reports, please check out the presentation by my colleague Janis Plume: eazyBI Community Days, Day-2 Training Presentations

In your case, to filter data by changes in the assignee field, you might use this approach:

1.Define a new calculated member in Assignee dimension and aggregate all assignees of “Group1”.

Aggregate({
  [Assignee].[Adam Shakespeare],
  [Assignee].[Tristan Dandelion]
})

In further calculations, I will refer to this calculated member as [Assignee].[Group1].

2.Define a new calculated measure in Measures. This measure will count issues which were assigned to the Group1 members at some point and currently are not assigned to any of Group1 members. The calculation might look like this:

NonZero(Count(
  --go through all issues
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    --issue was assigned to members from Group1
    ([Measures].[Transitions from assignee],
    [Assignee].[Group1],
    [Time].CurrentHierarchy.DefaultMember) > 0 AND
    --current assigne is not from Group1
    IsEmpty(
      ([Measures].[Issues created],
      [Assignee].[Group1],
      [Time].CurrentHierarchy.DefaultMember) )
  )
))

3.To filter by project, you may use Project dimension as page filter in the report.

Best,
Zane / support@eazyBI.com