I have a DE with the number of customers, like this:
I need to calculate the value for new customers daily, which would be the difference of Customer_Total for current day vs previous day. So, for 5/27/2021 it would be 10-5, for 5/28 21-10.
Getting an error
Errors: Old style JOIN (ANSI JOINs) syntax is not allowed.
when using below query:
SELECT ( (SELECT COUNT(*) FROM x WHERE datediff(day, Entry_Date, getdate()) = 0)) - (SELECT COUNT(*) FROM x WHERE datediff(day, Entry_Date, getdate()) = 1)) ) as counter
What is the best way query this in marketing cloud?