Healthscore Breakdown by CSM
I am trying to build out a pie chart for each of our CSMs that show the percentage breakdown of their red, yellow and green accounts. However, the Scorecard Fact data source doesn't allow grouping (not possible to add fields in the "By" section). What data source can I use to accomplish this? I see GS scorecards and Account Scorecard History among other options, but I am confused on how these are different and which one would be the best to use here.
Already have an account? Login
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
The net result is a pie chart of healthy using the pre-defined ranges/labels you set. This is also a dynamic report that will show just the accounts of the person that clicks it. So CSM-A will see their pie chart only, meanwhile CSM-B can click it and only see his/hers. This is perfect for a CSM Dashboard showing KPIs.
Hope this helps!
@Sarah, one other thing to note about what shows upon drill down is that you can select this by clicking the three dots (on drill down screen) and then selecting / unselecting the fields you want. If you save the report this config will persist.
Would you also know the difference between different data sources? I was using Account Scorecard History to build a similar pie chart and I also see GS Scorecard. I have limited experience building such reports so would love to understand the difference and the use case for each source. Much appreciated!
The Scorecard History stores the historical scores of the measures; Scorecard Fact (for Scorecards 2.0) stores the scores of the measures; Scorecard Master (Scorecards 2.0) stores all the scorecards. I used our object glossary for this info, and hopefully it helps you too!
The historical scores for Scorecard 2.0 are stored "Account Scorecard History" (this object stores a weekly snapshot of the measures, group scores & overall scores).
If you are using Scorecad 1.0 the historical scores are available in the "GS Scorecard" object.
Could you provide some info on the report you are trying to build on this object?
@Aditya, we are using Scorecards 2.0 so no wonder our GS Scorecard is empty. When you say historical scores for "Account Scorecard History", I wonder what the current score label here means.
Also, our "Scorecard Master" is empty. Since we have 2 separate scorecards for pre and post onboarding, we would like a pie chart that accumulates information from both scorecards.