+13Is there anyway to rearrange the order of the colors displayed in the stacked column scorecard habits report? We have Green, Lime, Orange, Red and Yellow, and they appear in that order. We’d prefer for them to appear in order of severity, so instead of red being in the middle, it should be the last one. We’d prefer this order: Green, Lime, Yellow, Orange then Red.
Best answer by davebrown2242
It is interesting (and possibly lazy) that alphabetical order is the route that is used in the default habits reporting. I created a workaround with a daily snapshot data space where we capture the scores. For example our Overall Healthscore for all accounts is captured ever night and we store them in fields for 1-Green, 2-Yellow, 3-Red — The only way I could get the colors into the correct order.
Seems like a lot of work for something that should acknowledge the levity of the prescribed scores.
+3It is interesting (and possibly lazy) that alphabetical order is the route that is used in the default habits reporting. I created a workaround with a daily snapshot data space where we capture the scores. For example our Overall Healthscore for all accounts is captured ever night and we store them in fields for 1-Green, 2-Yellow, 3-Red — The only way I could get the colors into the correct order.
Seems like a lot of work for something that should acknowledge the levity of the prescribed scores.
+4Sadly I had to do something similar to
Alternatively, I’ve used the numerical score to sort everything but then it doesn’t show green, yellow, red on the legend. Instead it shows a number which isn’t helpful for end-users.
This report is incredibly powerful but there isn’t a lot of functionality with it.
+13Thanks,
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
