Healthscore Breakdown by CSM 2018-07-17T20:58:35Z 2018-07-13T23:12:44Z 7763884 7763884 Healthscore Breakdown by CSM 2018-07-17T20:58:35Z 2018-07-13T23:12:44Z Sarah Kiani sarah_kiani 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.&nbsp; question shout_out_worthy shout_out_worthy complete 9 6 1 comment 19641546 Ben responded to "Healthscore Breakdown by CSM" 2018-07-16T11:46:50Z 2018-07-16T11:46:50Z Ben ben_michael_7959047 This is possible, and you can use the Scorecard Fact object. I put the SFDC Account ID in the Show Me area. Then you put the Current Score in the By area. I then apply two filters: one for Label != null and CSM = Current User. Here is a screenshot of the setup:<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1741046/RackMultipart20180716-94847-5tlw48-Screenshot_2018-07-16_064147_inlinepng1531741511" /><br /><br />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.<br /><br />Hope this helps! 2 19641900 Sarah Kiani responded to "Healthscore Breakdown by CSM" 2018-07-16T14:52:56Z 2018-07-16T14:52:56Z Sarah Kiani sarah_kiani Thanks a lot Ben! I realized the report type had switched to "scorecard mass edit" which is why the grouping got disabled. Would you know if we can click onto the pie chart and instead of the ids being displayed, we can see the account name? I want the CSMs to go to the account's C360 directly. Really appreciate your help! 0 19641915 Ben responded to "Healthscore Breakdown by CSM" 2018-07-16T14:57:53Z 2018-07-16T14:57:53Z Ben ben_michael_7959047 You could probably do that by changing out "SFDC Account ID" in the Show Me to be Account Name (or the equivalent on the Company Object). The only downside is that it *might not be a truly unique field (i.e. two accounts with the same name can exist). I would imagine that is unlikely, but technically possible. 0 19642175 Karl Rumelhart responded to "Healthscore Breakdown by CSM" 2018-07-16T16:57:43Z 2018-07-16T16:57:43Z Karl Rumelhart karl_rumelhart GREAT discussion!&nbsp; @Ben, you rock!<br /><br />@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.&nbsp; If you save the report this config will persist.&nbsp; 0 19642177 Karl Rumelhart responded to "Healthscore Breakdown by CSM" 2018-07-16T16:58:56Z 2018-07-16T16:58:56Z Karl Rumelhart karl_rumelhart Oh, and don't forget that you can rearrange the columns on the drill down by dragging them. 0 19642301 Sarah Kiani responded to "Healthscore Breakdown by CSM" 2018-07-16T17:58:35Z 2018-07-16T17:58:35Z Sarah Kiani sarah_kiani Super helpful! Thanks Ben and Karl :)<br /><br />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!&nbsp; 0 19642345 Lila Meyer responded to "Healthscore Breakdown by CSM" 2018-07-16T18:17:30Z 2018-07-16T18:17:30Z Lila Meyer lmeyer_gainsightcom Hi Sarah,<br /><br />The Scorecard History stores&nbsp;the historical scores of the measures; Scorecard Fact (for Scorecards 2.0) stores&nbsp;the scores of the measures;&nbsp;Scorecard Master (Scorecards 2.0) stores all the scorecards. I used our <a href="" rel="nofollow">object glossary</a> for this info, and hopefully it helps you too! 0 19644122 Aditya Marla responded to "Healthscore Breakdown by CSM" 2018-07-17T14:30:36Z 2018-07-17T14:30:36Z Aditya Marla aditya_marla Hi Sarah,<br /><br />The historical scores for Scorecard 2.0 are stored "Account Scorecard History"&nbsp; (this object stores a weekly snapshot of the measures, group scores &amp; overall scores).&nbsp;<br /><br />If you are using Scorecad 1.0 the historical scores are available in the "GS&nbsp;Scorecard" object.<br /><br />Could you provide some info on the report you are trying to build on this object?&nbsp; 1 19644962 Sarah Kiani responded to "Healthscore Breakdown by CSM" 2018-07-17T20:58:35Z 2018-07-17T20:58:35Z Sarah Kiani sarah_kiani Thanks Lila! Need to spend more time with the glossary :)<br /><br />@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. <br /><br /><img src="" title="Image:" /><br /><br />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. 0