1 Reply Latest reply on Feb 5, 2017 10:44 AM by Jim Dehner

    COUNTD Variance By Town On Prior Day vs. Last 10 Days

    Bryan Cassidy

      I'm pulling my hair out trying to get this to work; however, I have a list of [Towns] as rows and I'm doing a COUNTD on [CardNo] to help determine the number of unique debit/credit cards used in a specific town.  The data is uploaded every day containing prior day transactions so I'd love to know spot high variances indicating that more debit/credit cards are being used in a town as it could be fraud (e.g., counterfeit cards, etc.).  To get this to work though, I can easily figure out how to get the total population of [CardNo] but can't for the life of me try to get COUNTD to work on a given day for a specific town.