Trying to get the %change in overall Row Count DoD looking at today vs. yesterday.
This is what I have but is not successful. Any suggestions?:
(SUM(CASE WHEN DAY(`Snapshot Date`) = CURDATE() THEN `Row Count` ELSE 0 END)
-
SUM(CASE WHEN DAY(`Snapshot Date`) = CURDATE(-1) THEN `Row Count` ELSE 0 END))
/
SUM(CASE WHEN DAY(`Snapshot Date`) = CURDATE(-1) THEN `Row Count` ELSE 0 END)