It looks like the sorting on compose SDK charts is very limited. You cannot pass a predicate (callback function) to define your own sorting, you can only specify ascending or descending.
So, if that's the case, anytime we need to be able to sort a column by another column, we'll have to use the queryService and sort it ourselves.