Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,502
Community Members
 
Community Events
168
Community Groups

Percentage calculation with Label

Hi,

Let me share my problem with eazyBI. I need to calculate the following percentage:

Hours from issues with Label=FWK / Total number of hour of all issues.

It seem easy but it is not, although the number of label = FWK it is correctly shown in Rows but when trying to complete the formula in Measures, the value it is never coming.

I attach a document for more clarification.

Label percentage.pngThank you.
Ignacio.

 

3 answers

2 accepted

1 vote
Answer accepted

The correct second screenshot is:

[Measures].[Horas Framework vs Total %] =

[Measures].[Horas Framework]/[Measures].[Hours spent]

0 votes
Answer accepted

Hi,

 

The recommended solution is to use the standard calculation for the percentage of total:

Pasted_Image_16_11_2021__08_38.jpg

In this case, note that Label is a multi-value field, and hours are counted for all labels the issue has.

The formula of a custom measure if you wish to avoid the use of the Label dimension in the report:

 

([Measures].[Hours spent],
[Label].[FWK])
/
([Measures].[Hours spent],
[Label].DefaultMember)

Kindly,

Janis, eazyBI support

Thank you so much! I will try that.

Best regards.

Hi Janis,

That formula is what I definitely needed. Thank you so much.

Best regards.

Ignacio.

Sorry, there was a mistake in my screenshot. This is the correct one.

Suggest an answer

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

Apps for Confluence you won't want to miss: RSVP for September's Appy Hours

Calling all collaborators and Confluence users! Our Appy Hours event on September 29th features 4 presenters demoing functionality to superpower Confluence. Don't miss learning about these apps i...

123 views 0 9
Read article

Atlassian Community Events