I am curious if I can create a compound index with one field
ascending and the other descenging. With the syntax to create an
index, "Create Index" or Create descending index", it does not seem
possible.

If not what is the best way to create an index for something like this

"unit_sort, effective_date desc, iteration_number desc"

Above is one of the default sorts in one of the application's query.