Relative Content

Tag Archive for presto

Summing transactions over a 2-day period

I am trying to find a way to sum a transaction amount over a 30-day review period if the account had 2 or more distinct transactions that totaled $100 or more.

Finding data after fixed period during first transaction

I have a list of users that made a transaction between 03/05/2024 to 06/05/2024 for example. However, I want to know for this list of users, what is be their transaction data (ie gmv, txn count) 30 days after their transaction between that period.