Help with Formulas and Count when <=
Hi all, I am working on building a card that displays a count of cases that are less than 1, 2 and 7 days old from creation date. Currently using this formula for case age: SUM(UNIX_TIMESTAMP(CAST(NOW() AS DATETIME)) - UNIX_TIMESTAMP(CAST(`Created Date` AS DATETIME))) / 86400 This returns a decimal form in days which is…
