In this example, The Attempt and Completion columns are based on a user interactions my client does with certain customers. Not all customer receive this user interaction. If the customer receives this interaction they are counted as an attempt and if they do a "particular thing" after that interaction, they are considered a completion. My issue is that a single customer can receive multiple instances of this user interaction. For example, a single customer could experience Type A and Type B customer interaction. However, when I divide Completion/Attempt in my % Completion total, it ignores this thought process. The % Completion only counts this as 1 attempt instead of 2. In essence, the equations are the following for each column:
Attempt = sum of all customer interactions for unique customers
Completion = count of unique customers who receive a customer interaction and do a particular thing
% Completion = Completion / Attempt
I'm unable to show actual code, so please let me know if more clarification is needed.
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.