In UX Views, SortBy is overridden by GroupBy

[Michael2]

I have a status column that returns a text status. The default sorting behavior is to sort text values alphabetically.

I want to display these status values in a strict order so, using a SWITCH statement, I created a virtual column that returns a number based on the text value. This VC is called StatusSort.

SWITCH([Status],
“MISSING DATA”,1,
“NEED INJUNS”,2,
“READY TO RELEASE”,3,
“RELEASED TO PULL”,4,
“CLOSE INJUNS”,5,
0)

In a table view, I’d like to sort based on the VC StatusSort BUT, group based on status.
Because both Sort By and Group by have the option to sort, the sorting of sort by is overridden by the group by sorting.

I realize I could prepend these status’ with a number and then the list would sort according to the leading number, but at times not all status’ will apply and those that do would seem to be missing the others.

This seems okay

1. MISSING DATA
2. NEED INJUNS
3. READY TO RELEASE
4. RELEASED TO PULL
5. CLOSE INJUNS

Until it becomes…
2. NEED INJUNS
3. READY TO RELEASE
5. CLOSE INJUNS

Any suggestions as to how I can overcome this issue would be appreciated.

[Steve]

Michael:

I could prepend these status’ with a number and then the list would sort according to the leading number

That’s the only option, I’m afraid.

Michael:

but at times not all status’ will apply and those that do would seem to be missing the others

Yep.