Sort order with Class Function

[youss123]

Hi all,

I want to sort the four graphs :

problem 1 :  the x axis 

problem 2 :  the legend , i want to go from insufficent to high and the color red will be for insufficent , yellow for intermediate and green for high

dimension 1  : = replace(class([SCORE  1],10),'<= x <','->')

dimension 2 : 

= If([SCORE  1] >= -100 AND [SCORE  1] < -90, 'insufficient',

    If([SCORE  1] >= -90 AND [SCORE  1] < -80, 'insufficient',

    If([SCORE  1] >= -80 AND [SCORE  1] < -70, 'insufficient',

    If([SCORE  1] >= -70 AND [SCORE  1] < -60, 'insufficient',

        If([SCORE  1] >= -60 AND [SCORE  1] < -50, 'insufficient',

If([SCORE  1] >= -50 AND [SCORE  1] < -40, 'insufficient',

    If([SCORE  1] >= -40 AND [SCORE  1] < -30, 'insufficient',

    If([SCORE  1] >= -30 AND [SCORE  1] < -20, 'insufficient',

    If([SCORE  1] >= -20 AND [SCORE  1] < -10, 'insufficient',

        If([SCORE  1] >= -20 AND [SCORE  1] < -10, 'insufficient',

            If([SCORE  1] >= -10 AND [SCORE  1] < 0, 'insufficient',

            If([SCORE  1] >= 0 AND [SCORE  1] < 10, 'insufficient',

                If([SCORE  1] >= 10 AND [SCORE  1] < 20, 'intermediate',

                    If([SCORE  1] >= 20 AND [SCORE  1] < 30, 'intermediate',

                        If([SCORE  1] >= 30 AND [SCORE  1] < 40, 'high',

                            If([SCORE  1] >= 40 AND [SCORE  1] < 50, 'high',

                                If([SCORE  1] >= 50 AND [SCORE  1] < 60, 'high',

                                    If([SCORE  1] >= 60 AND [SCORE  1] < 70, 'high',

                                        If([SCORE  1] >= 70 AND [SCORE  1] < 80, 'high',

                                            If([SCORE  1] >= 80 AND [SCORE  1] < 90, 'high',

Expression : = count(DISTINCT Users)

Thank you in advance ++

 

[marcus_sommer]

Class() returned a dual() and could be therefore directly numeric sorted. But your replace() makes a string from it. If you don't like the default '<= x <' you could specify your wanted delimiter as the third parameter of class().

Also the nested if-loops could be simplified just by querying if the score is smaller as 10 and greater as 30.

[youss123]

Hi @marcus_sommer  thank you for your response.

from what I understood, the third parameter of class() replaces the value of x in a<=x<b not the form of the segment.

regards

[marcus_sommer · Accepted solution]

Ok. then you may resolve it in this way (simplified): dual(replace(class()), class())