Skip to main content
chuen_moschetti_1466d2
chuen_moschetti_1466d2
Contributor ⭐️⭐️⭐️⭐️
Aug 10, 2017 8:19 PM UTC

Report column ordering

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.

      6 replies

      dan_ahrens
      dan_ahrens
      Expert ⭐️⭐️⭐️
      Aug 10, 2017 8:27 PM UTC
      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
      Translate
      VP of Customer Success at Forcepoint
        chris_mudd
        Gainsight Employee ⭐️
        chris_mudd
        Gainsight Employee ⭐️
        Nov 14, 2017 9:02 PM UTC
        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.
        Translate
          idupulapati_tharuni_sai
          idupulapati_tharuni_sai
          Contributor ⭐️⭐️
          Nov 16, 2017 8:30 AM UTC
          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.
          Translate
            chuen_moschetti_1466d2
            chuen_moschetti_1466d2Author
            Contributor ⭐️⭐️⭐️⭐️
            Feb 5, 2018 4:26 PM UTC
            Just checking to see if the ability to reorder color/layout is actually coming out this month.
            Translate
            melissa_i_959be6
            melissa_i_959be6
            Contributor ⭐️⭐️⭐️⭐️⭐️
            Feb 22, 2018 5:56 PM UTC
            Yes, any update on the ability for us to define the label order rather than alphabetical/numerical?
            Translate
            dallis_king
            dallis_king
            Contributor ⭐️⭐️⭐️
            Feb 22, 2018 9:48 PM UTC
            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.
            Translate
            Terms & ConditionsAccessibility statement