Report column ordering

  • 5
  • Idea
  • Updated 7 months ago
  • Under Consideration
I've created a health score column chart by CSM, the colors are ordered from yellow, red, orange, lime, green instead of being ranked from red to green. I think we need the ability to adjust the ordinal scale in charts.
Photo of Chuen Moschetti

Chuen Moschetti, Champion

  • 1,536 Points 1k badge 2x thumb

Posted 1 year ago

  • 5
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,990 Points 20k badge 2x thumb
Hi Chuen,

This is because the labels are being sorted alphabetically. One way to mitigate that is to change your labels with a numerical prefix:
1 - Green
2 - Lime
3 - Yellow
4 - Orange
5 - Red

This will allow proper sorting in ROYLG order
Photo of Chris Mudd

Chris Mudd, Employee

  • 3,592 Points 3k badge 2x thumb
We are seeing this issue with creating a report off of NPS response too.  Currently we see Promoter at the bottom, Passive in the middle, and Detractor on top.  It would be very helpful if you could click and drag to re-order these for Promoter to be on top.
Photo of Idupulapati Tharuni Sai

Idupulapati Tharuni Sai, Employee

  • 220 Points 100 badge 2x thumb
We have already taken issue in to consideration, fixing this as part of 17'Winter release.
Fix will be all the legends should be in sorting order.
Photo of Chuen Moschetti

Chuen Moschetti, Champion

  • 1,536 Points 1k badge 2x thumb
Just checking to see if the ability to reorder color/layout is actually coming out this month.
Photo of Melissa I

Melissa I, Alum

  • 3,906 Points 3k badge 2x thumb
Yes, any update on the ability for us to define the label order rather than alphabetical/numerical?
Photo of Dallis King

Dallis King

  • 752 Points 500 badge 2x thumb
I would also appreciate this. I have scenarios where the labels are written as things like "1-6 months" ,"6-12 months", "12+ months" and the "12+ months" ends up in the middle instead of the end. Being able to manually order the labels would make my graphs much simpler to read.