In my situation when I use #Number of Records, it includes duplicate records so the only number that is unique is the caller phone number. So I did a count by phone number but now may conversions are off because that calculates number of records div by conversions.
How can I take a distinct count / calls converted = to get this percentage
I have attached my test workbook
Hi Tommy,
Thanks for the workbook. You were close. When using a Dimension (anything that has a blue icon next to the field name under tables), you generally can only count those, not SUM.
You noted that you have more than one unique Caller Number per Number of Records amt. So, it would be COUNTD([Caller Number]).
Which means, the % formula is: SUM([Calls Converted])/COUNTD([Caller Number]).
Thx, Don
If this answers your question please mark as Best Answer or if helpful please Upvote. Best, Don
