Hi All, I am struggling to find a way to custom sort data - see example data.
| Category | Score |
| positive | 0.5574 |
| neutral | 0.2732 |
| neutral | 0.25 |
| positive | 0.5912 |
| negative | -0.3612 |
| positive | 0.7184 |
| negative | -0.1419 |
| negative | -0.2411 |
The scores range from -1 to 1. I would like to sort the categories as in the example below to show the following:
Negative score smallest to largest, positive score largest to smallest and neutral score largest to smallest.
I have considered assigning the number 1 to negative and 2 to positive etc. to achieve custom ordering for the categories, though still need to order the scores as mentioned above.
| Category | Score |
| negative | -0.3612 |
| negative | -0.2411 |
| negative | -0.1419 |
| positive | 0.7184 |
| positive | 0.5912 |
| positive | 0.5574 |
| neutral | 0.2732 |
| neutral | 0.25 |
Thank you.
