This content has been marked as final. Show 4 replies
I'm trying to count a field with two conditions. How can I do that?
The field to be counted is [Ticket ID] and the conditions are State = ' New' and the diference between Now() and [Creation Date] > 30.
Count(if(State='New' AND interval(now()-[Creation Date], 'DD') > 30),[Ticket ID]))