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,363,785
Community Members
 
Community Events
168
Community Groups

How to create eazyBI measure using filter by component?

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

2 votes
Answer accepted

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

0 votes

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

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

Like Iago Docando likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events