Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Distinct values in eazyBI

I would like to get a summary of "hours spent with sub-tasks" by specific labels.  How can I make a custom measure to get the DISTINCT/UNIQUE "hours spent with sub-tasks", as the out of the box measure is giving me duplicates as an issue can have multiple labels?

1 answer

The measures of an issue having several label values are counted to all the labels which are used for the issue. It seems fine as it gives correct result for each particular label. It is not possible to detect at the issue level which one of the labels should be considered for the issue, so there is no general solution for this requirement.

However, when the measure is consolidated at the "All Labels" level the total amount does not duplicate for issues having several labels.

Perhaps a reasonable use case for the problem could be when using the labels on the report pages. When selecting multiple label values in the report pages, the measure multiplies by the number of labels the issue is having. To avoid this, a calculated measure can be used instead of the standard one dividing the multiplied value by the number of issues created. The formula would be like this:


Sum(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Hours spent with sub-tasks]>0),
[Measures].[Hours spent with sub-tasks]/[Measures].[Issues created]
)

Best regards,
eazyBI support.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Learn how to request and manage app requests in the Marketplace

G’day everyone! Super exciting news coming from the Marketplace. We have now fully rolled out the ability for end-users to submit app requests to admins directly from within the product! No longer ...

62 views 1 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you