Question

"There is data related to this Metric. Please delete those first and then try again."

  • 19 April 2017
  • 3 replies
  • 69 views

Userlevel 3
Badge
How do I go about cleaning up unused scorecards? I am getting an error that says 






"There is data related to this Metric. Please delete those first and then try again." but I don't see where to do so.

3 replies

Userlevel 7
Badge +2
Hi ,

Steps to delete
Account Scorecard Metrics


Step 1: Create a report on “Scorecard Fact” Object and check
if there are records present in it.



Step 2: If records are present in the object, ensure that
you delete those records.



Step 3: Use the following script to delete the records from the
Scorecard Fact object.



Important Please
change the Metric name in the following script.



The following query will delete only 9999 records from Scorecard
Fact object. If your record size is more than the limit mentioned, please
execute the query multiple times.



List<JBCXM__ScorecardFact__c>
scfact = [SELECT id, JBCXM__MetricId__r.name FROM JBCXM__ScorecardFact__c Where
JBCXM__MetricId__r.name = 'Metric name' LIMIT
9999];



Delete
scfact;



Step 4: Delete the Metric that you used in the above script
only after the query is executed.

Thanks,

Sairam

Userlevel 3
Badge
That worked, thanks! For anyone else that runs into this, this article helped me as well. https://gainsight.zendesk.com/hc/en-us/articles/221536387-Scorecards-Overall-score-calculation-incor...
Userlevel 7
Badge
Hi Jason,

I noticed that the support article you linked to is from our old help center which is no longer being updated. Please see the new site: https://support.gainsight.com/Product_Documentation/Scorecards/Troubleshooting/Scorecards_Overall_sc...

Any article URL that contains "zendesk" is from our old site. But I'm glad you found the content helpful!

Reply