How do you remove duplicates from scorecard fact reports?

  • 1
  • Question
  • Updated 3 months ago
  • Answered
When reporting with the Scorecard Fact object (where the name of your scorecard precedes "Scorecard Fact"), I am getting a TON of duplicate submissions on a per account basis. I can take care of this in some reports by using "count distinct" of SFDC ID in the Show Me section. 

However, I am trying to do a scatter plot with the Y-axis as "Avg Health Score" and the X-axis as "Customer Lifespan (Days)". I then group by SFDC ID. The issue is I get several submissions for each account and that throws off the whole scatter chart. I am not seeing a way to group by DISTINCT SFDC ID.  

Is there a good way to get this done?
Is there a better way to work with this data so I don't have to remove duplicates?
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
  • confident

Posted 3 months ago

  • 1
Photo of Aditya Marla

Aditya Marla, Employee

  • 2,746 Points 2k badge 2x thumb
Hi Ben,

The "Average Health Score" is the average of the "Overall Health Score"?

In the scorecard fact object, there will be an entry for every measure and its score. This might be the reason you are seeing multiple entries for a single account in the Fact object (Let me know if my understanding is incorrect here)



If you apply a measure filter (eg for the overall score) then you should see only one entry per account



Let me know if this is what you were looking for ?

Regards
(Edited)
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
That is perfect! I was wondering if that was why there were duplicates. I'll give this a shot!