How to create another business time left, elapsed time, elapsed percentage field?

[Kazuma Akita]

I would like to add a custom field to the Task SLA table that measures the SLA within 24 hours, excluding weekends and holidays, separate from the Business time left, elapsed time, and elapsed percentage fields.

Firstly, is it possible to implement such a custom field? If it is possible, please provide the steps to do so.

[AshishKM]

Hi @Kazuma Akita , 

I would suggest to use metric definiation over the record  table instead of adding/updating the task_sla table becuase that table is common for all Task ( and child ) table record and any modification will visible to all type of records. So technically possible with additional custome code for duration and % calculation. 

-Thanks,
AshishKM

[Kazuma Akita]

Hi @AshishKM 
Thank you for your answer!

Since my knowledge of Metric Definitions is limited, could you please provide more detailed steps if possible?

[Dr Atul G- LNG]

Hi @Kazuma Akita 

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/use/reporting/concept/c...

https://youtu.be/sejye-DCjok

[AshishKM]

You can review some existing metric definitions [table : metric_definition ] and check how they are configured. When metric definition meets the record condition it creates a record in metric instance table ( metric_instance )