-
Re: YTD vs Year Prior
@ArborRose this is the formula I just used and it returns what I need SUM(CASE WHEN DocDate <= DATE_SUB(CURDATE(),INTERVAL 1 YEAR) AND DocDate >= DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 1 YEAR)…1 -
New Customers/
Hello, I'm working on visualizations that aim to show new customers within years. My database contains data from 2020 moving forward. I want to see new/unique customers that bought from us for the fi…1
