Forum Discussion

Anya_T's avatar
Anya_T
Frequent Visitor
5 years ago
Solved

Quality Percentage

Hi,

 

I I have data in a column in this form

 

audit_sample_statusdecision
SAMPLE_UNPICKED 
SAMPLE_PICKEDCorrect
SAMPLE_UNPICKED 
NOT_SAMPLED 
SAMPLE_PICKEDCorrect
SAMPLE_PICKEDInorrect
SAMPLE_UNPICKED

 

 

I want to calculate quality percentage for sample picked data. How can i do this, what will be the best way to calculate quality?

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anya_T , Try a measure like

     

    divide(countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] = "Correct"), [audit_sample_status] ),
    countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] in{ "Correct" , "Inorrect" }), [audit_sample_status] ) )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anya_T , Try a measure like

     

    divide(countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] = "Correct"), [audit_sample_status] ),
    countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] in{ "Correct" , "Inorrect" }), [audit_sample_status] ) )