Creating a report using metrics table.

[Rajagopallan]

I would like to know how can metrics table be used to create a report for seeing the volume of tickets where the business process had been changed between any two different assignment groups.

[Sushil Chaudhar]

Hi,

Reporting on a metric is done using the database view that links the metric to the table on which it is defined.

You should create a database view on the Metric Instance table and the related table that you want to report.

The metric_instance table contains all required actual values and you may have to relate it to the actual table using its definition and ID columns on a database view.

Database View

--

Sushil

http://www.dxsherpa.com

[Rajagopallan]

Hi Sushil,

Thank you for your response.

I actually just have knowledge of creating an individual update set in the Development instance and then working on it. Database view is something new to me. Whether I will have to create an update set first before I do anything. I want to ensure that it does not have any impact in the Development instance.

Thank you

Rajagopallan V.

[Sushil Chaudhar]

Hi Rajagopallan,

I found below links for database views with update set

How to migrate database view in an update set

How to capture a database view in an update set

--

Regards,

Sushil

https://dxsherpa.com/

[Jaspal Singh]

Hi Rajagopalan,

Considering you have metric for assignment group in place you create Database view for metric as below

Additionally, you may refer link for better understanding.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.