Skip to main content
Solved

How to build a report on scorecard scores by CSMs?

nita_kim
Forum|alt.badge.img
  • nita_kim
  • Contributor ⭐️⭐️
  • 6 replies

Currently, reports on scores are shown as tables for the CSMs in a shared dashboard (with global filter set to current user). This way CSMs will get to see their own customers upon viewing the dashboard.

I’m wondering if it’s possible to build a widget (or pie chart, etc) that the global filter can be applied to as well. I’ve tried Count Aggregate the score for a widget with no luck, let alone trying to filter this by CSM.

 

Desired outcome: a widget that counts the customers with Green on a particular measure/score.


Any pointer on how to move this boulder will be much appreciated.

Best answer by rbegley

I made a small video that will hopefully help you.

https://drive.google.com/file/d/1i5IpjE2LJfZopnues5pIxmv0mUl6PWFp/view?usp=sharing

 

Here is the step by step:

  1. Create a new report off of one of the Scorecard Fact tables (either Unified or the one for your individual scorecard). 
  2. In Show Me, set a Count Distinct of Company ID or Company ID.SFDC Account ID to get unique Accounts
  3. Set to Widget Report type
  4. Add filter for measure by going through Measure ID to the Name field and searching for the Measure Name (in this example Cases).
  5. Add another filter for through Current Score ID to the Name field searching for Green.
  6. Add this report to a dashboard and use a global filter to filter for the specific CSM (this part is not shown).

Hope it helps.

 

Rob

View original
Did you find this topic helpful?

3 replies

rbegley
Forum|alt.badge.img
  • rbegley
  • Helper ⭐️⭐️
  • 55 replies
  • Answer
  • June 17, 2020

I made a small video that will hopefully help you.

https://drive.google.com/file/d/1i5IpjE2LJfZopnues5pIxmv0mUl6PWFp/view?usp=sharing

 

Here is the step by step:

  1. Create a new report off of one of the Scorecard Fact tables (either Unified or the one for your individual scorecard). 
  2. In Show Me, set a Count Distinct of Company ID or Company ID.SFDC Account ID to get unique Accounts
  3. Set to Widget Report type
  4. Add filter for measure by going through Measure ID to the Name field and searching for the Measure Name (in this example Cases).
  5. Add another filter for through Current Score ID to the Name field searching for Green.
  6. Add this report to a dashboard and use a global filter to filter for the specific CSM (this part is not shown).

Hope it helps.

 

Rob

john_apple
phani_kumar
lila_meyer
4 people like this
  • john_apple
    john_apple
  • phani_kumar
    phani_kumar
  • lila_meyer
    lila_meyer
  • sai_ram
    sai_ram
phani_kumar
Forum|alt.badge.img+3
  • phani_kumar
  • Gainsight Employee ⭐️⭐️
  • 332 replies
  • June 18, 2020

Hi @nita_kim 

I created a report using the Account Scorecard Fact Object. Below is the screenshot which describes the detail information like, each CSM wise how many Accounts were fallen with respect to the Label.

Screenshot:

 

Thanks.

sai_ram
Aleksandra_V
2 people like this
  • sai_ram
    sai_ram
  • Aleksandra_V
    Aleksandra_V
sai_ram
Forum|alt.badge.img+1
  • sai_ram
  • Expert ⭐️⭐️
  • 3727 replies
  • June 18, 2020

@rbegley and @phani_kumar Thanks was a quick response! Thanks, both!

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings