Best way to calculate duration of the ticket created on custom table ?

[Liyakhat]

we have a custom table which is not extended from task

we have a ticket on which we need to show to the agent how much time is elapsed once the ticket is created

we have created a field type duration and updating time for every minute on it using schedule job which runs every minute after the ticket is created filtering closed ones

will this effect performance? ,Any best possible way other than this to calculate time on a ticket 

[Dr Atul G- LNG]

Hi @Liyakhat  

Best way is create SLA Response and Resolution and use this for reporting.  

[Liyakhat]

@Dr Atul G- LNG 

Thanks for response ,The custom table is not extending task table

[Dr Atul G- LNG]

SLA can be applied to any table. Give a try and share feedback.

[Liyakhat]

@Dr Atul G- LNG  Nope I tried creating a custom table in my PDI and its not referenced in SLA definition