Forum Discussion
Solved
How to calculate days elapsed between transaction
Hello, I work for a non-profit and am trying to get insight into how frequently each of our donors contribute financially. I have a donor register with names, dates, amounts. I currently am summ...
If you're on 365, this might be your solution:
=LET(filtered,FILTER($F$2:$F$21,$D$2:$D$21=I2),dates,COUNT(filtered),IF(dates>1,AVERAGE(DROP(filtered,-1)-DROP(filtered,1)),filtered))
Can you please post few sample data (better to attach a sample excel file) and show your desired output.
Harun24HR thanks for your response.
I want to find the days between each transaction, per PayerID, for repeat donors.
This exercise seeks to find the frequency and ultimately average time between each transaction, per repeat donor.PayerID Amount Date Received 1458662946 51.1 11/4/2022 12167270467 200 11/4/2022 12131763519 110 11/3/2022 12131757642 25000 11/3/2022 7809555286 21 6/26/2022 7809555286 38 6/22/2022 7804539738 102.2 10/17/2022 7736255381 61.32 6/17/2022 7396511985 100 6/14/2022 7392399070 1000 6/12/2022 7392361055 40000 9/4/2022 7388445731 20.44 6/24/2022 7368787451 25 9/13/2022 7368787451 25 8/13/2022 7368787451 25.55 8/13/2022 7368787451 25 7/13/2022 7368787451 25.55 7/13/2022 7368787451 102.2 6/7/2022 7354195806 10 6/4/2022 7354184301 100 6/4/2022
