nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Roberts Čāčus - eazyBI

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

All comments

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.

Roberts Čāčus - eazyBI

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.

Best,

Roberts // support@eazybi.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-core

jira-core-server

eazybi