Our management wants an automated weekly report on client health scores and their associated comments but:
- I am unable to attach Unified Scorecard Fact Scorecard Mass Edit report type to a JO Email Template
- I am unable to create a custom object for reporting and populate it based on any filters on the Scorecard Comment because it is a RICHTEXTAREA field.
I want to be able to narrow down to the last week of at risk clients and associated health score comments for the overall score. I thought to even use Scorecard Timeline Mapping object, but there are all kinds of random text style markers as if it’s an HTML template (<p> etc.) which makes the comments difficult to read. Not to mention, I can’t find any documentation on the purpose of this object, “Scorecard Timeline Mapping” and how to use it.
Scorecard reporting has been historically very frustrating for us because of such limitations. If anyone knows of a workaround, please share!