Forum Discussion

ssk_1984's avatar
ssk_1984
Helper II
1 year ago
Solved

Custom Sort Row Header in Matrix visuals

HI Team,

 

Please help to custom sort the Category Column in the Matrix, here i have only manual sort. I dont want that, rather it should sort values by the below order

>100% as 1st order, 75% to 100% in 2 order and third would be <75%

Thanks in Advance

 

Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    1 year ago

    Hello
    I don't know if it's the best solution, what I think you could do is a column from 1 to 3, assigning the values to each one, that is:

    aa = if ( category = 0.75 , 1 , if ( category > 1 , 2 , if ( category < 0.75 , 3)))

    and then you sort the column according to that


    I clarify that I am not the one who knows the most, but it can be a band-aid solution while you find something better

    Best regards

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ssk_1984 ,

    Thanks for PVVBl00's reply!
    And ssk_1984 , you can add another simple table:

    Create relationship between two tables:

    And in the new table:


    Then replace the Category under Rows in your existing matrix visual object with the Category in the new table and sort it, and the final output is as below:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    1 year ago

    Hello
    I don't know if it's the best solution, what I think you could do is a column from 1 to 3, assigning the values to each one, that is:

    aa = if ( category = 0.75 , 1 , if ( category > 1 , 2 , if ( category < 0.75 , 3)))

    and then you sort the column according to that


    I clarify that I am not the one who knows the most, but it can be a band-aid solution while you find something better

    Best regards

    • ssk_1984's avatar
      ssk_1984
      Helper II
      1 year ago

      Thank you for your solution, I have tried multiple option to sort this Row values'Category'...But nothing works

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi ssk_1984 ,

        Thanks for PVVBl00's reply!
        And ssk_1984 , you can add another simple table:

        Create relationship between two tables:

        And in the new table:


        Then replace the Category under Rows in your existing matrix visual object with the Category in the new table and sort it, and the final output is as below:


        Best Regards,
        Dino Tao
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.