Need to create a report with Issues to calculate weighted defect count

Questions & Answers
1

I have to create a dashboard that represents Quality Debt for each project.

  1. All Open defects for a particular Stream
  2. Applying the formula for weighted defect count [(P1x10)+(P2x4)+(P3x2)+(P4x1)] /Divided By/[Total Count (P1+P2+P3+P4)]
    where
    P1 = Urgent & High Priority
    P2 = Medium
    P3 = Low
    P4 = Lowest

Can someone please help me on this, I’m really new to eazyBI

2

Hi @Komal_Varma ,
Welcome to eazyBI Community! :wave:

You can use tuples to create measure that includes the weighted defect count. Use measure “Issues due” to represent unresolved issues in the tuples. The formula would be like this (I added CASE statement to avoid dividing by zero):

CASE WHEN
  ([Priority].CurrentHierarchy.DefaultMember, [Measures].[Issues due])>0
THEN
  (([Priority].[P1], [Measures].[Issues due]) * 10 +
  ([Priority].[P2], [Measures].[Issues due]) * 4 +
  ([Priority].[P3], [Measures].[Issues due]) * 2 +
  ([Priority].[P4], [Measures].[Issues due]) * 1) /
  ([Priority].CurrentHierarchy.DefaultMember, [Measures].[Issues due])
END

best,
Gerda // support@eazyBI.com

3

Thank you so much @gerda.grantina!

You really made my day :pray:

1 Like