We've been using the Affected Services field to link our incidents and service requests. Now, the time has come to report on them. I have yet to find a good way to do so.
I've explored the following options:
1. Filters are unable to display the values of the "Affected Service" field
2. Exporting the filter into a CSV returns useless values such as "ServiceEntityReference{id='ari:cloud:graph::service/86083836-51fb-11eb-b2f2-0abe3f4a6601/713685a2-ae94-11eb-b1cd-128b42819424'}" which is impossible to view what service is actually in the field
3. No dashboard widgets are unable to use the "Affected Service" field as a metric
TLDR - Has anyone out there been able to efficiently report on affected services? For example, which of our services have had the most incidents in the last 2 weeks?