Forum Discussion
Custom Sort Row Header in Matrix visuals
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
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.
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:
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
Thank you for your solution, I have tried multiple option to sort this Row values'Category'...But nothing works
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.Thank you, Working fine