Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 columns:
SD.Customer Formatted Number | original dimension (caller number) | |
Customer Contact ID | basically an expression to correct the format | =IF(Index([SD.Customer Formatted Number],'tel:')>=1, KeepChar([SD.Customer Formatted Number], '+0123456789'), IF(index([SD.Customer Formatted Number], 'sip:')=0, [SD.Customer Formatted Number], mid([SD.Customer Formatted Number], 5))) |
Count([SD.Customer Formatted Number]) | count of calls | Count([SD.Customer Formatted Number]) |
Now, I want to count the number of callers that called more than once (email add not included)
Desired Result:
Date | Repeat callers |
5/8/2018 | 2 |
5/9/2018 | 3 |
Can you describe why those 2 rows only for 8/5/2018 ??
only those 2 callers have called more than once. (Please note that email add should not be counted as caller)
but those numbers are appeared only once in the file you shared
yeah.. i've already count the number of times they appeared so im now referencing on the last column "Count([Sd. formattednumber]) (as the number of times the caller called)