Forum Discussion
Anonymous
4 years agoNot applicable
Sort by repeating values
Hi Experts
I have repearting values in a column and i want to sort the data by increasing week bands... see sample data below
| 0 - 6 Week |
| 0 - 1 Week |
| 7 - 12 Week |
| 106 - 107 Week |
| 107 - 108 Week |
| 108 - 109 Week |
| 109 - 110 Week |
| 110 - 111 Week |
| 111 - 112 Week |
| 122 - 123 Week |
| 13 - 17 Week |
| 13 - 14 Week |
| 14 - 15 Week |
| 150 - 151 Week |
| 15 - 16 Week |
Hi Anonymous
You can do the following https://we.tl/t-RB37p59aXq
3 Replies
- tamerj1Community Champion
Hi Anonymous
You can do the following https://we.tl/t-RB37p59aXq - tamerj1Community Champion
Hi Anonymous
Would you please advise the expected result you're looking for?- AnonymousNot applicable
Hi - I was expecting something along the lines of
Sort_Bands = IF('reporting Diagnostics_Weekly_Waiting_MDS' = "0 - 1 Week", 0,IF('reporting Diagnostics_Weekly_Waiting_MDS' = "1 - 2 Week", 1,IF('reporting Diagnostics_Weekly_Waiting_MDS' = "2 - 3 Week", 2)))