I'm trying get the tickets count based on ticket status solved in a week. I'm trying to exclude tags values. But i'm not getting correct count with the below formula. not sure what is wrong here
IF (DATE_DIFF(NOW(), [Ticket solved - Timestamp], "nb_of_days") < "7" AND NOT INCLUDES_ANY([Ticket tags], "closed_by_merge")) THEN
Please sign in to leave a comment.