How do I report on Scorecard results? | Community
Skip to main content
M
MikeBr2
Level 2
May 2, 2017
Question

How do I report on Scorecard results?

  • May 2, 2017
  • 1 reply
  • 1907 views
I am trying to report the actual results from the scorecard and the only information I am seeing is the alignment, but my SVP wants to see the breakdown of the scores to get an idea of where the areas for improvement are in the project.
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    R
    RobertGo
    Level 3
    May 8, 2017
    I have not had to create a report or view of Scorecard results, but have you tried Project Details>Business Case>Export? It creates a PDF of the scorecard questions and answers for one project.
    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    November 30, 2022

    @nicholevargas Hi Nichole! I've started looking into my org using scorecards and I wanted to be sure I could report in the results easily first. In searching experience league, there are various questions and ideas over the past few years that people are having a hard time reporting on scorecard results across multiple projects and projects across multiple portfolios. It seems WF is not addressing this seemingly much-wanted aspect of reporting. There is a scorecard report type, but it doesn't bring in alignment scores/answers across multiple projects, you have to still click into each project to see the scores/answers. If you do a 'scorecard reporting' search in experience league you'll see the many threads. Do you know what is on the roadmap for improved scorecard reporting in Canvas or existing reporting? And if nothing, are you able to please take this up with the product team?

    If this helped you, please mark correct to help others : )
      A
      AmyLa6
      February 27, 2024

      Is there a way to report on the scorecard score as the total number of points instead of an alignment score and is it possible to pull this into a Project report?

       

      Thank you!


      I used Kellie's suggestion above and was able to have a column that gave the full answer and then another column right beside it that showed the score of each question by using. It doesn't give you the total, but maybe you could use this and find a way to write a formula to get the total: 

      aggregator.displayformat=doubleAsInt
      aggregator.function=SUM
      aggregator.valueexpression=SUM({scoreCardOption}.{value})
      aggregator.valueformat=doubleAsInt
      displayname=Scorecard Option Value
      listdelimiter=<div>
      listmethod=nested(alignmentValues).lists
      textmode=true
      type=iterate
      valueexpression=SUM({scoreCardOption}.{value})
      valueformat=HTML

       

      Here is a screenshot of the columns in and info: 

       

        Terms & ConditionsAccessibility statement

        Loading footer...