Report on Metric_Instance on alm_asset

[sabrinavilla]

Hi,

I created a metric on the alm_asset table to record changes in the substate field.

I want to create a report on the metric_instance table to show the number of assets with a particular value in substate filed but I also want to add some filters on the alm_asset table (e.g. company).

I am not able to do it.

Could you help me?

[Abbas_5 · Accepted solution]

Hi @sabrinavilla,
Based on your requirements you can add table name and condition,please refer to the below link:
https://www.servicenow.com/community/developer-forum/reporting-on-metric-instance/m-p/2235236

If it is helpful, mark it as a thumbs-up and accept the correct solution.
Thanks & Regards,
Abbas Shaik