Hi @bigboss,
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
Best,
Zane / support@eazyBI.com