How we can calculate the engineer's productivity

[Jyoti Malhotra]

Hi Team,

How we can calculate the engineer's productivity on incident ticket.

In below screen shot User ITIL worked from 11:52:43 to 11:58:05. 

I want to calculate the all engineers productivity on ticket.

Thanks

JM

[Jyoti Malhotra]

Hi Atul,

While creating DB View what condition should I give in Where Clause. So that in report it will show the correct duration time as per engineer name.

Thanks

JM

[Dr Atul G- LNG]

Hi @Jyoti Malhotra 

See this OOTB DB view

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/sys_db_view.do%3Fsys_id%3D2d722c6b0b01010100c3122d2939e03b%26sysparm_record_target%3Dsys_db_view%26sysparm_record_row%3D3%26sysparm_record_rows%3D12%26sysparm_record_list%3DnameCONTAINSmetric%255EORDERBYname

[Jyoti Malhotra]

Hi Atul,

I created the DB View. While creating report I gave DB View table name and click on Run report. After click on Run unable to see any record in report.

Thanks

JM

[Dr Atul G- LNG]

Hi @Jyoti Malhotra 

Are you able to see the data/results in DBView when you click on try. If you can see data then no issue with DB view else there is issue in DB view.

[Jyoti Malhotra]

Hi Atul,

When I clicked on Try it. It's giving me the error.

The condition I provided in where clause is 

Thanks

JM