Measure field completion

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.

Hi @tomahawk,

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

  1. 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.

  2. 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:

Best,
Zane / support@eazyBI.com