Measure field completion

tomahawk · June 21, 2019, 1:38pm

Hello,

I would like to have a KPI that measures field completion. I would like to know, for example, the % of issues for which the field “business value” has been completed.

Being new to eazyBI, I’d be very grateful for help.

Kind regards,

T.

zane.baranovska · July 19, 2019, 2:34pm

Hi @tomahawk,

The solution to calculate the percentage of business value completion depends on how this “Business Value” is represented in eazyBI.

For example, if “Busines Value” is a separate dimension, then you may define a new calculated measure in Measures. A calculation would divide a created issue amount with a particular “Busines Value” by all created issues. It might look like this:
```
 ( [Measures].[Issues created],
 [Business Value].[Completed] )
 /
 [Measures].[Issues created]
```
Set measure formatting to ##%, Integer percentage.
If “Busines Value” is a numerical value and imported as a measure in eazyBI, then you should have a custom measure Issues with Busines Value created. Then you may define a new calculated measure in Measures like this: Issues with Business Value created divide by Issues created.
```
 [Measures].[Issues with Business Value created]
 /
 [Measures].[Issues created]
```
Set measure formatting to ##%, Integer percentage.

Please see the documentation for more details:

What measures and dimensions are created in eazyBI when you import a custom field: https://docs.eazybi.com/eazybijira/data-import/custom-fields
How to build calculated measures: https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members

Best,
Zane / support@eazyBI.com