Skip to main content
Released

Same measure, multiple scorecards

Related products:CS Reports
jean.nairon
pele
dan_ahrens
gunjanm
CurtisValentine
  • jean.nairon
    jean.nairon
  • pele
    pele
  • dan_ahrens
    dan_ahrens
  • gunjanm
    gunjanm
  • CurtisValentine
    CurtisValentine

darkknight
Does anyone know if there is a way to comingle values for score measures that exist in two different scorecards into the same report?

I have a CSM Sentiment score that now lives in two scorecards.   It seems redundant to have to create two different reports to identify accounts where the CSM Sentiment is set.  Hoping someone has found another way.

9 replies

aditya_marla
  • Helper ⭐️⭐️⭐️
  • 482 replies
  • July 17, 2018
Hi Jeff,

Let me know if I understand correctly. There is a CSM sentiment score that is used in multiple scorecards...and you want to create a single report to see the 'current' sentiment score across all accounts (irrespective of the scorecard)? Since the data exists on two separate fact objects...you would need to create different reports (one for each fact object). As an alternative, you can use a rule to populate the score value of the measure onto the Company object & build a report on it.

darkknight
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 1980 replies
  • July 17, 2018
Yes that is correct.  I figured that was probably going to be the answer. 

What we need, though, is a way to put all the scores in one place, searchable, regardless of which scorecard fact table it belongs to.  Requiring end users to use multiple reports to search for score values is cumbersome.  

Can this be converted to an idea?

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • July 18, 2018
Hi Jeff, part of the challenge with this is that Scorecards 2.0 provides the flexibility for different customers to have different measures (not just different weights). So you might have one segment or stage or region of customers that have 5 measures, but others that have 10 measures or they may have measures that are totally different from each other (and other segments/stages/regions/etc). 

Any thoughts on if showing ALL the scores for ALL the various scorecards and types in a single grid would be more helpful or harmful? And considering that weights could be different, showing all scores on a single grid would raise questions about why two accounts with similar component values could have vastly different overall scores. 

An example of how that table might look if accounts that don't share the same scorecard model are combined:


darkknight
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 1980 replies
  • July 19, 2018
I see your point.  Perhaps grouping them by Scorecard name would help?

At the same time though, there has to be a way to make this more flexible than having to create a rule to copy the values from multiple scorecards to a single column on the Company object to try and accomplish what I'm trying to accomplish.  This may be a workaround, but until that rule runs everyday, the CSM Sentiment on the Company object could potentially be stale.

darkknight
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 1980 replies
  • July 19, 2018
Aditya - how would I grab the Score value of a particular measure?  When I create a rule off of a Scorecard Fact Table, I can filter on a Measure name, but there appears to be no Score field related to that Measure - the only score value available is the Current Score - which is the overall score value.


dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • July 19, 2018
Hi Jeff, the field you want to pull in is "Current score Id -> Score"

See example below




darkknight
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 1980 replies
  • July 19, 2018
Believe it or not, that's what I thought I had pulled in Dan.  Thanks for correcting my error!

lila_meyer
Forum|alt.badge.img+5
  • Gainsight Employee ⭐️⭐️⭐️
  • 1447 replies
  • July 20, 2018
Is there still an open product enhancement request here? Happy to convert to an Idea if so...

darkknight
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 1980 replies
  • July 24, 2018
Yes please and thank you.

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