How to create eazyBI measure using filter by component?

Allen Culpepper November 5, 2020

Hello, 

I'm new to eazyBI and am stumped on if this is possible and how to accomplish it. Any help would be greatly appreciated.

 

I am trying to create a calculation either using jira automation or eazyBI (I need it in the report) like below.

Component name =  "DEFECT"

I basically want to calculate % Defect = Total Story points for all issues tagged with component "DEFECT" / (Total Sprint Story Points Committed)

 

Hopefully I am being clear.

Thanks!

 

2 answers

1 accepted

3 votes
Answer accepted
Roberts Čāčus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 9, 2020

Hi @Allen Culpepper ,

In eazyBI, Components are part of the Project dimension. For a particular Project, you can define a formula similar to the one below:

([Project].[Rocket Engineering].[Defect],
[Measures].[Story Points created])

It will return the number of Story Points in issues from the Project "Rocket Engineering" and the Component "Defect". To get the calculation you are looking for, try the formula below:

([Project].[Rocket Engineering].[Defect],
[Measures].[Story Points created])
/
([Project].[Rovket Engineering],
[Measures].[Sprint Story points committed])

See the eazyBI documentation page for more details on calculated measures - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.

If you have several Projects with the component "Defect", please look at our documentation page for details on how to import Components as a dimension of its own - https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Component.

 

Best,

Roberts // support@eazybi.com

1 vote
Iago Docando
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 5, 2020

Hello, there :)

I don't really know eazyBI (first time I hear about it) but just in the off chance they're not monitoring this forum I've thought about doing a quick search and pointing you towards their contact form.

https://eazybi.com/contact

Also, they have a really comprehensive documentation, it seems. Hopefully you can find your answer there. 

https://docs.eazybi.com/eazybi

Allen Culpepper November 6, 2020

Thanks Iago, I have the doc link but still unsure, but I am also new to eazyBI. 

Like # people like this

Suggest an answer

Log in or Sign up to answer