can anyone say me from which table does the agile metric is in

[Trupti Krishnam]

And how can we create a agile metric to capture total analysis effort .., If any example please do suggest

thanks 

[Anand Kumar P · Accepted solution]

Hi @Trupti Krishnam ,

By creating a database view connecting the metric_instance table and the rm_story table, you can use this view to gather data related to Analysis Story Points and track the analysis effort. This data can be used for reporting and analysis of your Agile process.

To get exact number of Analysis Story Points assigned can vary between teams and organizations, as it's a relative measure. The key is to use it consistently to track and manage the analysis effort effectively in an Agile environment.
Please mark it as solution proposed and helpful if it works for you.
Thanks,

Anand