Try this source="servername" Assignee="*" GroupName="TierII" OR GroupName="TierIII" | stats min(DateTimeAssign) AS begin max(DateTimeAcknow) AS end by CallID,GroupName,Assignee,Priority | eval duration=round(end-begin) | eval Created=strftime(begin," %b %d, %Y %T %p") | eval Closed=strftime(end," %b %d, %Y %T %p") | stats avg(duration) as avgDuration values(CallID) values(Created) as Assigned values(Closed) as Ack by GroupName | fieldformat avgDuration = tostring(avgDuration,"duration") ... View more