You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am trying to generate a report to count the number of bugs created per week. I am looking for the distinct value.
I am also filtering out one of my Components (using a calculated member in the Projects section) using this formula:
However, the report I am getting does not provide the distinct value of bugs. (I know, because when I drill into the reported value, I see that the row count is lower than the total value.)
How can I get the graph to count issues once?
Perhaps, you try using one of the distinct measures from "Measures" dimension.
For example, "Issues created count"
Martins / eazyBI team
Here is why.
Let's say issue has two components "CompA" and "CompB" and then you create a calculated member to aggregate all components except "CompC".
Since both issue's components belong to the calculated member (they both are not CompC), the issue is counted twice (one time for each of two components that belongs to the aggregate) when using "Issues created" measure.
However "Issues created count" is a distinct measure that knows how to count the issue just once per aggregate.
I hope that explains the challenge with multi-value field dimensions in eazyBI.