I apologize if I'm unable to provide more information. Hopefully this helps. Thanks so much for the help!!
Attempts = count the distinct customers where Interaction Type is not 'Not a Type'
Completions = count the distinct customers where interaction is not 'Not a Type' and Attribute = Green
% Completion = Attempts / Completions
Give these equations a single caller could experience Type A and Type B and be counted as 1 in the column for each. However, by using this formula, the total will show only 1 customer. I went to the "Total Mode" feature for the Attempts Expression and changed from "Expression Total" to "Sum of Rows" and this fixed the formula for Attempts. However, I'm unsure how to fix this issue for the % Completion expression.
I want to take the sum of Attempt and divide by the Sum of completions for the % Completion expression.
Interaction Type Column
Not a Type