Metrics are not visible under metric definition for sc_req_item table.

[Kartik Swaroop]

Hi ,
I've created a metrics for request item table but records are not visible.

and there one database view for request item table

Would you guys please help here,  i need to create a metric report for request item table.

[HilJam]

Hi @Kartik Swaroop  , 

You can get this kind of data using Performance Analytics and  creating a Historical dta collection job. Create a PA script that calculates duration 

https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/performance-analytics/task/t...

[HilJam]

Hi @Kartik Swaroop , 

You can get this data using Performance Analtyics and configuring a Historical Data Collection job. 

https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/performance-analytics/task/t...