How to create eazyBI measure using filter by component?

[Allen Culpepper]

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!

[Roberts Čāčus · Accepted solution]

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

[Iago Docando]

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]

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