Hi
How can I create a calculated measure based on this query:
(reporter in (reporter1, reporter2, reporter3) OR assignee in (assignee1, assignee2, assignee3))
Hi
How can I create a calculated measure based on this query:
(reporter in (reporter1, reporter2, reporter3) OR assignee in (assignee1, assignee2, assignee3))
Hi @guinevere,
A query considering both dimensions with OR
, suggests that eazyBI has to iterate through individual issues and consider both options for each issue. My colleague Zane discussed translating JQL into MDX in his eazyBI community days presentation - Training videos on specific topics.
In your case, the calculated measure formula could look similar to the one below:
Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
CoalesceEmpty([Issue].CurrentMember.Get('Assignee name'),'') MATCHES '(alinda|admin|dsnow)'
OR
CoalesceEmpty([Issue].CurrentMember.Get('Reporter name'),'') MATCHES '(alinda|admin|dsnow)'
),
[Measures].[Issues created]
)
Replace the values '(alinda|admin|dsnow)'
with your user keys. Please look at our documentation page for more information on defining calculated measures - Calculated measures and members.
Best,
Roberts // support@eazybi.com