HI,
Trying to use the below to count when both criteria are met. If an agent has a record for a specific date count 1.
(CASE WHEN (COUNT(DISTINCT `ReportDate`)) >= '1' and (COUNT(DISTINCT `Agents`)) >= '1' THEN '1' ELSE ? END)
It is not allowing me to calculate this. Can someone please assist?