Quality Percentage

[Anya_T]

Hi,

I I have data in a column in this form

audit_sample_status	decision
SAMPLE_UNPICKED
SAMPLE_PICKED	Correct
SAMPLE_UNPICKED
NOT_SAMPLED
SAMPLE_PICKED	Correct
SAMPLE_PICKED	Inorrect
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?

[amitchandak · Accepted solution]

@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] ) )