How do i chain multiple conditions that evaluate to single True/False
below I am trying to count job_id where job_created_at is not in December 2022. It is removing all Decembers and the entire 2022.
countIf({job_id},
(extract('MM', {job_created_at}) <> 12 AND extract('YYYY', {job_created_at}) <> 2022 )
)
I can achieve the desired result with below but was thrown back that the above didn’t work
countIf({job_id},
(truncDate("MM", {job_created_at}) <> parseDate('12/01/2022', 'MM/dd/yyyy'))
)