So it doesn't look like report builder will let you directly set the related query on the metric instance table - likely because of the m2m nature and joining on a document_id field. However if you're comfortable following the below, it's a workable solution.
Create a new report data source by going to "Report Sources" application menu or to sys_report_source table.
The above covers the 2nd requirement, but we need to add the 1st.
If you have SN-Utils installed (highly recommend the plugin) you can double-click the 'filter' label to amend the filter query to the following
reassignment_count=0^state=7^active=false^RLQUERYmetric_instance.id,=0^definition=35f2b283c0a808ae000b7132cd0a4f55^value=On Hold^ENDRLQUERY
If you don't, you can edit the filter query via a script
var metricGr = new GlideRecord('sys_report_source');
if(metricGr.get('27bd4e1f83b182105e43c4a6feaad399')){ //Replace with sys_id of report source created
metricGr.setValue('filter' , 'reassignment_count=0^state=7^active=false^RLQUERYmetric_instance.id,=0^definition=35f2b283c0a808ae000b7132cd0a4f55^value=On Hold^ENDRLQUERY');
metricGr.update()
}
Your users can then use this in report builder
