Hi all,
I'm trying to calculate between signup and the first sale:
DATEDIFF(`sale_date`,`signup_date`)
Which works fine. Only problem is, is when a person makes multiple sales it does counts towards the average. Is there a way to ignore any other instance and pick only the earliest date?
Thanks in advance