I am new to eazy BI. Please help me with below problem. Thanks
We are recording date and time stamp of tickets in specific statuses like on hold , in progress, off hold and by default created time, resolved will be available.
My ask is I need to calculate Wait time = in progress - created
effort time = resolved - in progress (If ticket doesn’t go to on hold)
effort time = (on hold-in progress) + ( resolved-Off hold) [If ticket goes to off hold]
and I need average wait time(In days or Hours) per team i.e if team A completed 10 ticktes then Average effort time for team a = Total tickets effort time /10
Note: teams are span across two countries so need to consider time zone.