We had almost the exact same issue, but with Major Incident rather than Incident. Thanks to a suggestion from Adam Stout, we managed to get it to work.
1. Set up your Interactive Filter, with type Reference, pointed to the Incident Table with a filter on Number (because it won't let you pick sys_id).
Create your interactive filter reference. You can't reference incident itself, so instead point it at any table that references incident: (maybe parent_incident? or Problem)? and set the field to the incident reference.
Click the i to open the record you created, then right click to export to XML
In the XML, edit the reference_table and set to incident - edit the reference_field and set to sys_id
Save it, then go back to the instance and import the xml file back in (you may have to ask an admin to help, if you're not admin yourself).
Now when you look at the Filter Reference, it should reflect the incident table and sys_id field.
Add your Interactive Filter to the dashboard, and make sure your other report widgets are set to "Use Interactive Filter", and it should follow!
Hello, I edited the XML file to show/reference sys_ID
But, the interactive filter still will not interact with the metric_instance table. The incident #'s are populating in the filter, just not interacting with the graph. [yes, I have the option to interact turned on]
We had almost the exact same issue, but with Major Incident rather than Incident. Thanks to a suggestion from Adam Stout, we managed to get it to work.
1. Set up your Interactive Filter, with type Reference, pointed to the Incident Table with a filter on Number (because it won't let you pick sys_id).
Create your interactive filter reference. You can't reference incident itself, so instead point it at any table that references incident: (maybe parent_incident? or Problem)? and set the field to the incident reference.
Click the i to open the record you created, then right click to export to XML
In the XML, edit the reference_table and set to incident - edit the reference_field and set to sys_id
Save it, then go back to the instance and import the xml file back in (you may have to ask an admin to help, if you're not admin yourself).
Now when you look at the Filter Reference, it should reflect the incident table and sys_id field.
Add your Interactive Filter to the dashboard, and make sure your other report widgets are set to "Use Interactive Filter", and it should follow!
