RITM Open Date to first SCTask Assigned To duration

[Guru6]

Need to create a metric to get the below duration

RITM Open Date  to

First SCTask Assigned To is not empty

[AshishKM · Accepted solution]

Hi @Guru6 , 

Write metric definition on catalog task [sc_task] table  on "assigned to" first update ( empty -> user ) and read the RITM created value via dot walking and get the duration with current date/time and RITM created date/time.

Write the metric definition code and share if stuck some where.

-Thanks,
AshishKMishra