I want a question. Below example, I want to subtract [Members].[C]. But, here is important things that [Members].[C] when [Members].[A] is included.
“[Members].[A] + [Members].[B] -
[Members].[A] IN [Members].[C] THEN
Please help me. I am very desperate.
There are several techniques for calculated measures to subtract duplicates.
For the Jira issues cube, a few measures would show a unique issue count even if the issue is assigned to members A and C. For example, “Issues created count” and “Issues resolved count”. See the documentation of available metrics: Jira Core measures and dimensions
you can use calculated measuresfor more complex use cases. Here are several community posts on similar topics:
You might want to watch this training video on how to translate JQL (Jira query language) criteria to the eazyBI reports and calculations for a better understanding of the data and how they are related:
Filter Data: How to Translate JQL to eazyBI
Zane / support@eazyBI.com