I need help sorting out a beast mode calculation that shows agent pass rate.

sbailey
sbailey ⚪️
edited January 4 in Beastmode & Analytics

Hi All,

We use the following to calculate a compliance pass rate at the evaluation level:


100 - (COUNT(DISTINCT

CASE

WHEN `answer_label`!= 'N/A' 

AND `question_max_score`!=`answer_value` AND `name_group`= 'Compliance Critical' THEN `evaluation_id`

END)

/COUNT(DISTINCT `evaluation_id`))*100


I am trying to adjust this to run at the question level for accuracy, but I can not get it to work even though it's showing as a valid formula:


100 - (COUNT(DISTINCT

CASE

WHEN `answer_label`!= 'N/A' 

AND `question_max_score`!=`answer_value` AND `name_group`= 'Customer Critical' THEN COUNT(DISTINCT `question_description` )

END)

/ COUNT(ABS(`question_description`)))*100


Any ideas of what could be happening?