3 Replies Latest reply on Nov 30, 2016 11:11 PM by Norbert Maijoor

    How to identify split payments

    Won-Suk Kim

      Hi

       

      I want to show potential split in credit card transactions. I am working on employee credit card usage records and want to filter credit card transactions which occurred at the same venue & on the same date but over different time intervals, say, within 5 minutes or so. I have dimensions such as vendor number, credit card number, transaction date and time (down to seconds). So if vendor number and date are identical but multiple transactions occured within 5 minutes, I think there is a high chance of split payment.

       

      1) same vendor number, same credit card number, same date, but different transaction time -> split by one person

      2) same vendor number, different credit card number, same date, different transaction time -> split by more than one person

       

      Can you suggest functions or ways to show these on dashboard?