Workaround For Out of Order Labels on Scorecard Chart

  • 3
  • Problem
  • Updated 2 months ago
  • Solved
I have created some charts showing the breakdown of health scores by Success Package type and yet the scores are not displayed in order.  How can I get them to go in the correct order, as configured in the Scorecard administration page. 

Additionally, the labels in the key for my scorecard bar chart shown below are out of order.  Does anyone know of a work around (besides naming them "1-Watch", "2-Neutral", "3-Good", "4-Great")


Thanks!
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb

Posted 2 months ago

  • 3
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,802 Points 20k badge 2x thumb
Hi Kate, as you noted, the order is based on alphabetical sorting. Prefixing with a number is a valid solution. Another solution that's specific to your data would be to change "Great" to "Awesome" (or really anything that is better than Good and would come before Good alphabetically). :-)
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb
Thanks yea that's what I figured.  Would changing the names of the labels change the order of the colors in the bar charts too? 

Seems like this could be an enhancement for Scorecard because people aren't going to always want to change their Health labels to suit alphabetical order.  Since it's configured elsewhere (in Scorecard 2.0) in a specific order, maybe that could translate into reporting better.
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb
I attempted to change the names of the labels and what has happened is the color scheme changed too.  Now, as you can see from the below dashboard, the colors aren't even consistent throughout the reports (note Neutral is red in one report and green in other and blue in yet another).  Why did the color convention switch to my default pallet when I changed the names of my labels to include a 1, 2, 3, 4, and 5?
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,802 Points 20k badge 2x thumb
Hi Kate,

Yes, changing the labels will change the order of the stacking in the stacked bar chart to match your sequence.

When you changed your labels did you also go into your Custom Color configuration and ensure that you had the custom colors defined for the new labels that you created?



If specific matches do not exist for your new label types, the default palette will be assigned to those labels.
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb
Ok, so you're saying that if we use anything other than the system default Label names (Great, Good, Neutral, Watch, and At Risk), then we need to define at the Report Builder level a custom color palette for the following:

Object: [Name of Scorecard] Scorecard Fact
Field: Current Score ID > Label

Correct?