Skip to main content
morgan_albright
morgan_albright
Contributor ⭐️⭐️
June 14, 2018
Solved

Scorecard 2.0 Historical Trend Report

  • June 14, 2018
  • 7 replies
  • 493 views
I would like to build
a report that shows historical overall scores and Risk scores, at least for the
last 4 weeks.  The scorecards show the weekly history: 



Ideally, we'd like to have all of this data in a report so we can better monitor the average trend in an Overall Health score as well as another Measure we use, Risk Score. I've played around with the Scorecard Scorecard Fact objects and Usage Data objects, but cannot get it to work. Any help would be appreciated.
    Best answer by aditya_marla
    Hi Morgan,

    Could you provide some more details on how you want to see the report? As in do you want a way to report on the accounts where there was a score change WoW?
    Would a report like this work? (Where you can see what the score was WoW for all the accounts)
    ?

    7 replies

    aditya_marla
    aditya_marla
    Helper ⭐️⭐️⭐️
    June 15, 2018
    Hi Morgan,

    Do you use Scorecard 2.0 ? This data will be present it the "Account/Relationship Scorecard History" object
      morgan_albright
      morgan_albrightAuthor
      Contributor ⭐️⭐️
      June 15, 2018
      Perfect! Grouping by "Snapshot Date" was what I hadn't tried in the Account Scorecard History. Thank you!
        morgan_albright
        morgan_albrightAuthor
        Contributor ⭐️⭐️
        June 18, 2018
        Is there a way that we can make a list with this object on which accounts had a scorecard value change week by week?
          aditya_marla
          aditya_marlaAnswer
          Helper ⭐️⭐️⭐️
          June 20, 2018
          Hi Morgan,

          Could you provide some more details on how you want to see the report? As in do you want a way to report on the accounts where there was a score change WoW?
          Would a report like this work? (Where you can see what the score was WoW for all the accounts)
          ?

          collin_reeser
          collin_reeser
          Contributor ⭐️
          June 29, 2018


          Along the same lines, we are able to build a trend report for one account on C360 but would like a list view of health trend by all accounts. Example attached. 
            ml2019
            ml2019
            Contributor ⭐️⭐️⭐️⭐️⭐️
            October 1, 2019
            I'm lookng for something similar but with a filter that only shows accounts if the score declined. Any suggestions?

            (I've played around with "previous score" field and comparing with "current score" but since it appears previous score field only updates weekly, this approach only works at the end of the week)

            A
            asiatillotson
            Contributor ⭐️⭐️
            October 11, 2021

            Hi Morgan,

            Could you provide some more details on how you want to see the report? As in do you want a way to report on the accounts where there was a score change WoW?
            Would a report like this work? (Where you can see what the score was WoW for all the accounts)
            ?

            12877-1fuskun_inline.png

            Hi Aditya, 

            How did you manage to produce the above? If I replicate the show me and group by fields, I seem to see the below: 

             

            Thanks,

            Asia

             

            Terms & ConditionsAccessibility statement