Hello everybody,
Could you help me, I have to make a condition of a field. I require a count of a field (Abandonment, attended), with the following conditions:
If the field closed_by = 'Abandoned by agent', 'Not attended by agent', 'Agents not available' 'User canceled'), 'Abandonment', 'Attended'
where this last record (User cancels), must still be conditioned,
if (closed_by = 'User canceled', if (duration> = '00: 01: 00 ',' Abandoned ',' attended '))
I still can't show the correct results.
I would greatly appreciate your support.